DBA Data[Home] [Help]

APPS.INV_INVTOPKL_XMLP_PKG dependencies on WIP_ENTITIES

Line 423: WIP_ENTITIES WE,

419: CURSOR C_WIP_ENTITY_TYPE IS
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

Line 435: WIP_ENTITIES WE,

431: WO.OPERATION_SEQ_NUM OPERATION,
432: BD.DEPARTMENT_CODE DEPARTMENT,
433: TO_CHAR(NULL) START_DATE
434: FROM
435: WIP_ENTITIES WE,
436: WIP_LINES WL,
437: BOM_DEPARTMENTS BD,
438: WIP_OPERATIONS WO,
439: WIP_DISCRETE_JOBS WDJ,

Line 461: WIP_ENTITIES WE,

457: BD.DEPARTMENT_CODE DEPARTMENT,
458: TO_CHAR(WRS.FIRST_UNIT_START_DATE) START_DATE
459: FROM
460: MTL_SYSTEM_ITEMS_KFV MSIK,
461: WIP_ENTITIES WE,
462: WIP_LINES WL,
463: BOM_DEPARTMENTS BD,
464: WIP_OPERATIONS WO,
465: WIP_REPETITIVE_SCHEDULES WRS,

Line 490: WIP_ENTITIES WE,

486: BOS2.OPERATION_SEQ_NUM OPERATION,
487: BD.DEPARTMENT_CODE DEPARTMENT,
488: TO_CHAR(NULL) START_DATE
489: FROM
490: WIP_ENTITIES WE,
491: WIP_LINES WL,
492: BOM_DEPARTMENTS BD,
493: BOM_OPERATION_SEQUENCES BOS2,
494: BOM_OPERATION_SEQUENCES BOS,