APPS.INV_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_LINES

Line 1763: , rcv_shipment_lines rsl

1759: , NULL secondary_uom --OPM Convergence
1760: , NULL secondary_uom_code --OPM Convergence
1761: , NULL secondary_quantity --OPM Convergence
1762: FROM rcv_shipment_headers rsh
1763: , rcv_shipment_lines rsl
1764: , po_requisition_headers porh
1765: , po_requisition_lines porl
1766: , mtl_system_items msi
1767: , mtl_system_items msi1

Line 2139: -- Get the transfer_cost_group_id from rcv_shipment_lines

2135: END IF;
2136:
2137: l_rcv_transaction_rec.rcv_shipment_line_id := l_rcpt_match_table_detail(match_result_count).shipment_line_id;
2138:
2139: -- Get the transfer_cost_group_id from rcv_shipment_lines
2140: BEGIN
2141: SELECT cost_group_id
2142: INTO l_rcv_transaction_rec.transfer_cost_group_id
2143: FROM rcv_shipment_lines

Line 2143: FROM rcv_shipment_lines

2139: -- Get the transfer_cost_group_id from rcv_shipment_lines
2140: BEGIN
2141: SELECT cost_group_id
2142: INTO l_rcv_transaction_rec.transfer_cost_group_id
2143: FROM rcv_shipment_lines
2144: WHERE shipment_line_id = l_rcv_transaction_rec.rcv_shipment_line_id;
2145: EXCEPTION
2146: WHEN OTHERS THEN
2147: IF (l_debug = 1) THEN

Line 3250: FROM rcv_shipment_lines rsl

3246: , pod.task_id task_id
3247: , NULL secondary_uom --OPM Convergence
3248: , NULL secondary_uom_code --OPM Convergence
3249: , NULL secondary_quantity --OPM Convergence
3250: FROM rcv_shipment_lines rsl
3251: , rcv_shipment_headers rsh
3252: , po_headers poh
3253: , po_line_locations poll
3254: , po_lines pol

Line 3416: , rcv_shipment_lines rsl

3412: , NULL secondary_uom --OPM Convergence
3413: , NULL secondary_uom_code --OPM Convergence
3414: , NULL secondary_quantity --OPM Convergence
3415: FROM rcv_shipment_headers rsh
3416: , rcv_shipment_lines rsl
3417: , po_requisition_headers porh
3418: , po_requisition_lines porl
3419: , mtl_system_items msi
3420: , mtl_system_items msi1