DBA Data[Home] [Help]

APPS.INV_INVTOPKL_XMLP_PKG dependencies on WIP_ENTITIES

Line 414: WIP_ENTITIES WE,

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

Line 426: WIP_ENTITIES WE,

422: WO.OPERATION_SEQ_NUM OPERATION,
423: BD.DEPARTMENT_CODE DEPARTMENT,
424: TO_CHAR(NULL) START_DATE
425: FROM
426: WIP_ENTITIES WE,
427: WIP_LINES WL,
428: BOM_DEPARTMENTS BD,
429: WIP_OPERATIONS WO,
430: WIP_DISCRETE_JOBS WDJ,

Line 452: WIP_ENTITIES WE,

448: BD.DEPARTMENT_CODE DEPARTMENT,
449: TO_CHAR(WRS.FIRST_UNIT_START_DATE) START_DATE
450: FROM
451: MTL_SYSTEM_ITEMS_KFV MSIK,
452: WIP_ENTITIES WE,
453: WIP_LINES WL,
454: BOM_DEPARTMENTS BD,
455: WIP_OPERATIONS WO,
456: WIP_REPETITIVE_SCHEDULES WRS,

Line 481: WIP_ENTITIES WE,

477: BOS2.OPERATION_SEQ_NUM OPERATION,
478: BD.DEPARTMENT_CODE DEPARTMENT,
479: TO_CHAR(NULL) START_DATE
480: FROM
481: WIP_ENTITIES WE,
482: WIP_LINES WL,
483: BOM_DEPARTMENTS BD,
484: BOM_OPERATION_SEQUENCES BOS2,
485: BOM_OPERATION_SEQUENCES BOS,