DBA Data[Home] [Help]

APPS.INV_INVTOPKL_XMLP_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 415: MTL_TXN_REQUEST_LINES MTRL

411: SELECT
412: WE.ENTITY_TYPE
413: FROM
414: WIP_ENTITIES WE,
415: MTL_TXN_REQUEST_LINES MTRL
416: WHERE MTRL.LINE_ID = LINE_ID
417: AND WE.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID;
418: CURSOR C_DISCRETE_INFO IS
419: SELECT

Line 431: MTL_TXN_REQUEST_LINES MTRL

427: WIP_LINES WL,
428: BOM_DEPARTMENTS BD,
429: WIP_OPERATIONS WO,
430: WIP_DISCRETE_JOBS WDJ,
431: MTL_TXN_REQUEST_LINES MTRL
432: WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
433: AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
434: AND WDJ.LINE_ID = wl.line_id (+)
435: AND WDJ.ORGANIZATION_ID = wl.organization_id (+)

Line 457: MTL_TXN_REQUEST_LINES MTRL

453: WIP_LINES WL,
454: BOM_DEPARTMENTS BD,
455: WIP_OPERATIONS WO,
456: WIP_REPETITIVE_SCHEDULES WRS,
457: MTL_TXN_REQUEST_LINES MTRL
458: WHERE MSIK.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID
459: AND MSIK.ORGANIZATION_ID = WE.ORGANIZATION_ID
460: AND WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
461: AND WE.ORGANIZATION_ID = WRS.ORGANIZATION_ID

Line 488: MTL_TXN_REQUEST_LINES MTRL

484: BOM_OPERATION_SEQUENCES BOS2,
485: BOM_OPERATION_SEQUENCES BOS,
486: BOM_OPERATIONAL_ROUTINGS BOR,
487: WIP_FLOW_SCHEDULES WFS,
488: MTL_TXN_REQUEST_LINES MTRL
489: WHERE WE.WIP_ENTITY_ID = WFS.WIP_ENTITY_ID
490: AND WE.ORGANIZATION_ID = WFS.ORGANIZATION_ID
491: AND WL.LINE_ID = WFS.LINE_ID
492: AND WL.ORGANIZATION_ID = WFS.ORGANIZATION_ID