eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPSMUT dependencies on BOM_OPERATION_SEQUENCES

Line 2456: stamped. Hence, we use BOM_OPERATION_SEQUENCES and

2452: WHERE transaction_id = p_transaction_id;
2453:
2454: /* Scenario applicable for jobs that are upgraded
2455: from 11i.8 and below. JOB_OPERATION_SEQ_NUM is not
2456: stamped. Hence, we use BOM_OPERATION_SEQUENCES and
2457: starting_operation_seq_num on the transaction in WSRJ to get
2458: this information */
2459:
2460: IF l_operation_seq_num IS NULL THEN

Line 2466: BOM_OPERATION_SEQUENCES BOS

2462: SELECT wo.operation_seq_num
2463: INTO l_operation_seq_num
2464: FROM WIP_OPERATIONS WO,
2465: WSM_SM_RESULTING_JOBS WSRJ,
2466: BOM_OPERATION_SEQUENCES BOS
2467: WHERE WSRJ.transaction_id = p_transaction_id
2468: AND nvl(wsrj.starting_intraoperation_step, 1) = 1
2469: AND wsrj.common_routing_sequence_id = bos.routing_sequence_id
2470: AND wsrj.starting_operation_seq_num = bos.operation_seq_num

Line 3447: BOM_OPERATION_SEQUENCES BOS

3443: SELECT wo.operation_seq_num
3444: INTO l_operation_seq_num
3445: FROM WIP_OPERATIONS WO,
3446: WSM_SM_RESULTING_JOBS WSRJ,
3447: BOM_OPERATION_SEQUENCES BOS
3448: WHERE WSRJ.transaction_id = p_txn_id
3449: AND nvl(wsrj.starting_intraoperation_step, 1) = 1
3450: AND wsrj.common_routing_sequence_id = bos.routing_sequence_id
3451: AND wsrj.starting_operation_seq_num = bos.operation_seq_num