ORA-00918 Column ambiguously defined
Publicado por Pablo (4 intervenciones) el 22/02/2019 01:50:03
Buen dia,
Por favor podrian ayudarme a saber porque me marca el error ORA-00918 Column ambiguously defined de la siguiente consulta?
SELECT ITEM,PLANNER_CODE,SCHED_FC_DATE,TO_SHIP_QTY,WIP_ENTITY_NAME
FROM MWC_MEX_SCHED_SHIPMENTS_V, WIP_DISCRETE_JOBS JOBS, WIP_ENTITIES WIP, MTL_SYSTEM_ITEMS INV
WHERE WIP.PRIMARY_ITEM_ID = INV.INVENTORY_ITEM_ID AND
WIP.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID AND
WIP.ORGANIZATION_ID = INV.ORGANIZATION_ID AND
INV.ORGANIZATION_ID = JOBS.ORGANIZATION_ID AND
JOBS.ORGANIZATION_ID = 99 AND
JOBS.START_QUANTITY > 0 AND
JOBS.STATUS_TYPE = 3 AND
PLANNER_CODE = '4-1502' AND
ROWNUM <= 10
Muchas Gracias,
Por favor podrian ayudarme a saber porque me marca el error ORA-00918 Column ambiguously defined de la siguiente consulta?
SELECT ITEM,PLANNER_CODE,SCHED_FC_DATE,TO_SHIP_QTY,WIP_ENTITY_NAME
FROM MWC_MEX_SCHED_SHIPMENTS_V, WIP_DISCRETE_JOBS JOBS, WIP_ENTITIES WIP, MTL_SYSTEM_ITEMS INV
WHERE WIP.PRIMARY_ITEM_ID = INV.INVENTORY_ITEM_ID AND
WIP.WIP_ENTITY_ID = JOBS.WIP_ENTITY_ID AND
WIP.ORGANIZATION_ID = INV.ORGANIZATION_ID AND
INV.ORGANIZATION_ID = JOBS.ORGANIZATION_ID AND
JOBS.ORGANIZATION_ID = 99 AND
JOBS.START_QUANTITY > 0 AND
JOBS.STATUS_TYPE = 3 AND
PLANNER_CODE = '4-1502' AND
ROWNUM <= 10
Muchas Gracias,
Valora esta pregunta


0