APPS.CSP_MO_MTLTXNS_UTIL dependencies on CSP_MOVEORDER_LINES

Line 148: from csp_moveorder_lines

144:
145: -- validate whether the move_order_line_id exists
146: BEGIN
147: select header_id into l_header_id
148: from csp_moveorder_lines
149: where line_id = p_move_order_line_id;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_message.set_name ('CSP', 'CSP_INVALID_MOVEORDER_LINE');

Line 160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);

156: WHEN OTHERS THEN
157: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
158: fnd_message.set_token('ERR_FIELD', 'p_move_order_line_id', FALSE);
159: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
160: fnd_message.set_token('TABLE', 'csp_moveorder_lines', FALSE);
161: FND_MSG_PUB.ADD;
162: RAISE EXCP_USER_DEFINED;
163: END;
164: END IF;

Line 256: FROM CSP_MOVEORDER_LINES

252: l_line_id NUMBER;
253: l_line_status NUMBER := -1;
254: CURSOR l_mo_header_csr IS
255: SELECT line_id
256: FROM CSP_MOVEORDER_LINES
257: WHERE header_id = p_move_order_header_id;
258:
259: BEGIN
260: OPEN l_mo_header_csr;

Line 607: FROM csp_moveorder_lines

603: WHERE packlist_line_id = p_packlist_line_id
604: and organization_id = p_organization_id;
605: CURSOR l_Get_Moveorder_Headers(l_line_id NUMBER) IS
606: SELECT distinct header_id
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;