DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_LINES

Line 1761: , rcv_shipment_lines rsl

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

Line 2062: -- Get the transfer_cost_group_id from rcv_shipment_lines

2058: END IF;
2059:
2060: l_rcv_transaction_rec.rcv_shipment_line_id := l_rcpt_match_table_detail(match_result_count).shipment_line_id;
2061:
2062: -- Get the transfer_cost_group_id from rcv_shipment_lines
2063: BEGIN
2064: SELECT cost_group_id
2065: INTO l_rcv_transaction_rec.transfer_cost_group_id
2066: FROM rcv_shipment_lines

Line 2066: FROM rcv_shipment_lines

2062: -- Get the transfer_cost_group_id from rcv_shipment_lines
2063: BEGIN
2064: SELECT cost_group_id
2065: INTO l_rcv_transaction_rec.transfer_cost_group_id
2066: FROM rcv_shipment_lines
2067: WHERE shipment_line_id = l_rcv_transaction_rec.rcv_shipment_line_id;
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: IF (l_debug = 1) THEN

Line 3146: FROM rcv_shipment_lines rsl

3142: , pod.task_id task_id
3143: , NULL secondary_uom --OPM Convergence
3144: , NULL secondary_uom_code --OPM Convergence
3145: , NULL secondary_quantity --OPM Convergence
3146: FROM rcv_shipment_lines rsl
3147: , rcv_shipment_headers rsh
3148: , po_headers poh
3149: , po_line_locations poll
3150: , po_lines pol

Line 3312: , rcv_shipment_lines rsl

3308: , NULL secondary_uom --OPM Convergence
3309: , NULL secondary_uom_code --OPM Convergence
3310: , NULL secondary_quantity --OPM Convergence
3311: FROM rcv_shipment_headers rsh
3312: , rcv_shipment_lines rsl
3313: , po_requisition_headers porh
3314: , po_requisition_lines porl
3315: , mtl_system_items msi
3316: , mtl_system_items msi1