DBA Data[Home] [Help]

APPS.WIP_WS_EXCEPTIONS dependencies on WIP_OPERATION_RESOURCES

Line 195: WIP_OPERATION_RESOURCES

191: SAVEPOINT WIPVEXC;
192:
193: --Select row, if RESOURCE id has changed.
194: SELECT COUNT(*) INTO L_ROW_COUNT FROM
195: WIP_OPERATION_RESOURCES
196: WHERE
197: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
198: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
199: RESOURCE_SEQ_NUM = P_RESOURCE_SEQ_NUM AND

Line 253: WIP_OPERATION_RESOURCES

249:
250: --Select row, if RESOURCE ID OR DEPTT ID has changed.
251: --SINCE WE HAVE DEPTT CODE, WE NEED DEPTT ID FROM BOM_DEPTT
252: SELECT COUNT(*) INTO L_ROW_COUNT FROM
253: WIP_OPERATION_RESOURCES
254: WHERE
255: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
256: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
257: RESOURCE_SEQ_NUM = P_RESOURCE_SEQ_NUM AND

Line 329: WIP_OPERATION_RESOURCES WOR

325: (
326: SELECT
327: RESOURCE_SEQ_NUM
328: FROM
329: WIP_OPERATION_RESOURCES WOR
330: WHERE
331: WOR.ORGANIZATION_ID = P_ORGANIZATION_ID AND
332: WOR.WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
333: WOR.OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND