APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 44: from mtl_txn_request_lines

40: l_quantity_delivered number;
41:
42: cursor c_quantity_delivered is
43: select quantity_delivered
44: from mtl_txn_request_lines
45: where line_id = p_line_id;
46:
47: begin
48: open c_quantity_delivered;

Line 90: from mtl_txn_request_lines

86: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
87:
88: cursor c_header_id is
89: select header_id
90: from mtl_txn_request_lines
91: where line_id = p_line_id;
92:
93: begin
94: open c_header_id;

Line 430: FROM mtl_txn_request_lines

426: IF (px_line_id IS NOT NULL) THEN
427: BEGIN
428: SELECT line_id
429: INTO l_line_id
430: FROM mtl_txn_request_lines
431: WHERE line_id = px_line_id
432: AND organization_id = p_organization_id;
433:
434: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');

Line 448: from mtl_txn_request_lines

444: END IF;
445:
446: select nvl(max(line_number), 0)
447: into l_line_num
448: from mtl_txn_request_lines
449: where header_id = p_header_id;
450:
451: l_line_num := l_line_num + 1;
452: l_trolin_tbl(l_order_count).header_id := p_header_id;