DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 223: FROM AHL_PRD_DISPOSITIONS_B A

219: * R12 Drop 4 - SQL ID: 14399309
220: * Bug #4918991
221: */
222: SELECT DISPOSITION_ID
223: FROM AHL_PRD_DISPOSITIONS_B A
224: WHERE
225: A.WORKORDER_ID = C_WORKORDER_ID AND
226: A.DISPOSITION_ID = C_DISP_ID;
227:

Line 828: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI

824: * Bug #4918991
825: */
826: /*
827: SELECT 'x'
828: FROM AHL_PRD_DISPOSITIONS_B DISP, AHL_WORKORDERS WO, CSI_ITEM_INSTANCES CSI
829: WHERE
830: DISP.INSTANCE_ID = CSI.INSTANCE_ID AND
831: DISP.WORKORDER_ID = WO.WORKORDER_ID AND
832: WO.WIP_ENTITY_ID = CSI.WIP_JOB_ID AND