DBA Data[Home] [Help]

APPS.INV_INVTOPKL_XMLP_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 424: MTL_TXN_REQUEST_LINES MTRL

420: SELECT
421: WE.ENTITY_TYPE
422: FROM
423: WIP_ENTITIES WE,
424: MTL_TXN_REQUEST_LINES MTRL
425: WHERE MTRL.LINE_ID = LINE_ID_P --bug12674388
426: AND WE.WIP_ENTITY_ID = MTRL.TXN_SOURCE_ID;
427: CURSOR C_DISCRETE_INFO IS
428: SELECT

Line 440: MTL_TXN_REQUEST_LINES MTRL

436: WIP_LINES WL,
437: BOM_DEPARTMENTS BD,
438: WIP_OPERATIONS WO,
439: WIP_DISCRETE_JOBS WDJ,
440: MTL_TXN_REQUEST_LINES MTRL
441: WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
442: AND WE.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
443: AND WDJ.LINE_ID = wl.line_id (+)
444: AND WDJ.ORGANIZATION_ID = wl.organization_id (+)

Line 466: MTL_TXN_REQUEST_LINES MTRL

462: WIP_LINES WL,
463: BOM_DEPARTMENTS BD,
464: WIP_OPERATIONS WO,
465: WIP_REPETITIVE_SCHEDULES WRS,
466: MTL_TXN_REQUEST_LINES MTRL
467: WHERE MSIK.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID
468: AND MSIK.ORGANIZATION_ID = WE.ORGANIZATION_ID
469: AND WE.WIP_ENTITY_ID = WRS.WIP_ENTITY_ID
470: AND WE.ORGANIZATION_ID = WRS.ORGANIZATION_ID

Line 497: MTL_TXN_REQUEST_LINES MTRL

493: BOM_OPERATION_SEQUENCES BOS2,
494: BOM_OPERATION_SEQUENCES BOS,
495: BOM_OPERATIONAL_ROUTINGS BOR,
496: WIP_FLOW_SCHEDULES WFS,
497: MTL_TXN_REQUEST_LINES MTRL
498: WHERE WE.WIP_ENTITY_ID = WFS.WIP_ENTITY_ID
499: AND WE.ORGANIZATION_ID = WFS.ORGANIZATION_ID
500: AND WL.LINE_ID = WFS.LINE_ID
501: AND WL.ORGANIZATION_ID = WFS.ORGANIZATION_ID