APPS.CSTPSMCW dependencies on WIP_OPERATIONS

Line 505: wip_operations wo

501: AND status = WIP_CONSTANTS.COMPLETED
502: AND EXISTS ( SELECT 'Queue Intraop'
503: FROM wsm_sm_resulting_jobs rj,
504: bom_operation_sequences bos,
505: wip_operations wo
506: WHERE rj.transaction_id = txn.transaction_id
507: AND rj.starting_intraoperation_step = 1
508: AND (nvl(rj.job_operation_seq_num,
509: wo.operation_seq_num), wo.organization_id) =

Line 511: FROM wip_operations wo2

507: AND rj.starting_intraoperation_step = 1
508: AND (nvl(rj.job_operation_seq_num,
509: wo.operation_seq_num), wo.organization_id) =
510: (SELECT min(operation_seq_num), wo2.organization_id
511: FROM wip_operations wo2
512: WHERE wo2.wip_entity_id = rj.wip_entity_id
513: AND wo2.organization_id = rj.organization_id
514: GROUP BY wo2.organization_id)
515: AND rj.transaction_id = txn.transaction_id

Line 667: FROM WIP_OPERATIONS WO,

663: obtain this information */
664: IF l_starting_op_seq IS NULL THEN
665: SELECT wo.operation_seq_num
666: INTO l_starting_op_seq
667: FROM WIP_OPERATIONS WO,
668: WSM_SM_RESULTING_JOBS WSRJ,
669: BOM_OPERATION_SEQUENCES BOS
670: WHERE WSRJ.transaction_id = l_wsmt_transaction_id
671: AND nvl(wsrj.starting_intraoperation_step, 1) = 1