DBA Data[Home] [Help]

APPS.WIP_WIPDJDSP_XMLP_PKG dependencies on WIP_OPERATIONS

Line 97: FROM WIP_OPERATIONS

93: + SUM(QUANTITY_RUNNING)
94: + SUM(QUANTITY_REJECTED)
95: + SUM(QUANTITY_WAITING_TO_MOVE))
96: INTO QUANTITY_REM_IN_PREV
97: FROM WIP_OPERATIONS
98: WHERE WIP_ENTITY_ID = WE_ID_p
99: AND ORGANIZATION_ID = org_id
100: AND OPERATION_SEQ_NUM < OP_SEQ_p;
101: RETURN (QUANTITY_REM_IN_PREV);