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.CSP_MO_MTLTXNS_UTIL dependencies on DUAL

Line 611: FROM dual;

607: FROM csp_moveorder_lines
608: WHERE line_id = l_line_id;
609: CURSOR l_Get_txn_header_id_csr IS
610: SELECT mtl_material_transactions_s.nextval
611: FROM dual;
612: CURSOR l_Get_Packlist_Status_Csr(l_packlist_header_id NUMBER) IS
613: SELECT packlist_status
614: FROM csp_packlist_headers
615: WHERE packlist_header_id = l_packlist_header_id;

Line 625: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;

621: AND organization_id = p_organization_id
622: AND period_close_date is null
623: AND nvl(open_flag,'Y') = 'Y';
624: CURSOR l_Get_Serial_Temp_id_Csr IS
625: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
626:
627: CURSOR l_Get_Packlist_Csr (l_packlist_header_id NUMBER) Is
628: SELECT
629: PACKLIST_HEADER_ID ,

Line 2602: FROM dual;

2598: l_csp_mtltxn_rec CSP_MATERIAL_TRANSACTIONS_PVT.CSP_Rec_Type;
2599: EXCP_USER_DEFINED EXCEPTION;
2600: Cursor l_Get_txn_header_id_csr IS
2601: SELECT mtl_material_transactions_s.nextval
2602: FROM dual;
2603:
2604: CURSOR l_ml_records IS
2605: SELECT
2606: TRANSACTION_HEADER_ID ,

Line 2965: CURSOR l_Get_Serial_Temp_id_Csr IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;

2961: SELECT * FROM mtl_transaction_lots_temp
2962: WHERE transaction_temp_id = p_old_transaction_temp_id
2963: AND lot_number = p_lot_number
2964: ORDER BY TRANSACTION_QUANTITY DESC;
2965: CURSOR l_Get_Serial_Temp_id_Csr IS SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval FROM dual;
2966:
2967: --- Subfunction transact_serial
2968: Procedure transact_serial(
2969: -- p_new_transaction_temp_id IN NUMBER,