APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 47: from mtl_txn_request_lines

43: l_other_line_id number;
44:
45: cursor c_quantity_delivered is
46: select quantity_delivered
47: from mtl_txn_request_lines
48: where line_id = p_line_id;
49:
50: begin
51:

Line 100: from MTL_TXN_REQUEST_lines

96: l_other_line_id := 0;
97:
98: select header_id
99: into l_mo_header_id
100: from MTL_TXN_REQUEST_lines
101: where line_id = p_line_id;
102:
103: select count(line_id )
104: into l_other_line_id

Line 105: from MTL_TXN_REQUEST_lines

101: where line_id = p_line_id;
102:
103: select count(line_id )
104: into l_other_line_id
105: from MTL_TXN_REQUEST_lines
106: where header_id = l_mo_header_id
107: and line_id <> p_line_id;
108:
109: if l_other_line_id = 0 then

Line 145: from mtl_txn_request_lines

141: x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
142:
143: cursor c_header_id is
144: select header_id
145: from mtl_txn_request_lines
146: where line_id = p_line_id;
147:
148: begin
149: open c_header_id;

Line 485: FROM mtl_txn_request_lines

481: IF (px_line_id IS NOT NULL) THEN
482: BEGIN
483: SELECT line_id
484: INTO l_line_id
485: FROM mtl_txn_request_lines
486: WHERE line_id = px_line_id
487: AND organization_id = p_organization_id;
488:
489: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARAMETER_EXISTS');

Line 503: from mtl_txn_request_lines

499: END IF;
500:
501: select nvl(max(line_number), 0)
502: into l_line_num
503: from mtl_txn_request_lines
504: where header_id = p_header_id;
505:
506: l_line_num := l_line_num + 1;
507: l_trolin_tbl(l_order_count).header_id := p_header_id;