APPS.CSTPSMCW dependencies on BOM_OPERATION_SEQUENCES

Line 504: bom_operation_sequences bos,

500: AND costed = WIP_CONSTANTS.PENDING
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,

Line 662: Use Bom_operation_sequences and wsrj.starting_op_seq_num to

658: FROM WSM_SM_RESULTING_JOBS WSRJ
659: WHERE transaction_id = l_wsmt_transaction_id;
660:
661: /* For Pre 11i.8 jobs, JOB_OPERATION_SEQ_NUM is NULL,
662: Use Bom_operation_sequences and wsrj.starting_op_seq_num to
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

Line 669: BOM_OPERATION_SEQUENCES BOS

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
672: AND wsrj.common_routing_sequence_id = bos.routing_sequence_id
673: AND wsrj.starting_operation_seq_num = bos.operation_seq_num