APPS.INV_RCV_STD_TRANSFER_APIS dependencies on RCV_SHIPMENT_LINES

Line 507: FROM rcv_shipment_lines

503:
504: BEGIN
505: SELECT cost_group_id
506: INTO p_rcv_transaction_rec.transfer_cost_group_id
507: FROM rcv_shipment_lines
508: WHERE shipment_line_id = p_rcvtxn_rec.shipment_line_id;
509: EXCEPTION
510: WHEN OTHERS THEN
511: p_rcv_transaction_rec.transfer_cost_group_id := NULL;

Line 1196: , rcv_shipment_lines rsl

1192: , rs.to_locator_id from_locator_id
1193: FROM rcv_transactions rt
1194: , rcv_supply rs
1195: , rcv_shipment_headers rsh
1196: , rcv_shipment_lines rsl
1197: , po_lines pol
1198: , mtl_system_items msi
1199: WHERE rs.rcv_transaction_id = v_rcv_txn_id
1200: AND rs.to_organization_id = p_organization_id

Line 1631: , rcv_shipment_lines rsl

1627: , rs.to_locator_id from_locator_id
1628: FROM rcv_transactions rt
1629: , rcv_supply rs
1630: , rcv_shipment_headers rsh
1631: , rcv_shipment_lines rsl
1632: , mtl_system_items msi
1633: WHERE rs.rcv_transaction_id = v_rcv_txn_id
1634: AND rs.to_organization_id = p_organization_id
1635: AND rs.rcv_transaction_id = rt.transaction_id

Line 2047: , rcv_shipment_lines rsl

2043: , rs.to_locator_id from_locator_id
2044: FROM rcv_transactions rt
2045: , rcv_supply rs
2046: , rcv_shipment_headers rsh
2047: , rcv_shipment_lines rsl
2048: , mtl_system_items msi
2049: WHERE rs.rcv_transaction_id = v_rcv_txn_id
2050: AND rs.to_organization_id = p_organization_id
2051: AND rs.rcv_transaction_id = rt.transaction_id

Line 2597: FROM rcv_shipment_lines

2593: l_progress := 40;
2594:
2595: SELECT shipment_header_id
2596: INTO l_shipment_header_id
2597: FROM rcv_shipment_lines
2598: WHERE shipment_line_id = p_reference_id;
2599:
2600: IF (l_debug = 1) THEN
2601: print_debug('Current Progress: ' || l_progress ||

Line 2988: rcv_shipment_lines rsl,

2984: ,rsl.asn_line_flag asn_line_flag
2985: FROM rcv_supply rs,
2986: rcv_transactions rt,
2987: rcv_serials_supply rss,
2988: rcv_shipment_lines rsl,
2989: rcv_shipment_headers rsh,
2990: mtl_serial_numbers_interface msni
2991: WHERE rs.item_id = p_item_id
2992: -- AND Nvl(rs.item_revision,nvl(p_revision,'@@@')) = nvl(p_revision,'@@@') BUG13562127

Line 3039: rcv_shipment_lines rsl,

3035: ,msni.transaction_interface_id transaction_interface_id
3036: ,rsl.asn_line_flag asn_line_flag
3037: FROM rcv_supply rs,
3038: rcv_transactions rt,
3039: rcv_shipment_lines rsl,
3040: rcv_shipment_headers rsh,
3041: mtl_serial_numbers_interface msni,
3042: mtl_transaction_lots_interface mtli
3043: WHERE rs.item_id = p_item_id

Line 3093: rcv_shipment_lines rsl,

3089: ,decode(rt.uom_code, p_transfer_uom_code, (p_transfer_quantity - rs.quantity), 0) ORDERING2
3090: ,rsl.asn_line_flag asn_line_flag
3091: FROM rcv_supply rs,
3092: rcv_transactions rt,
3093: rcv_shipment_lines rsl,
3094: rcv_lots_supply rls,
3095: rcv_shipment_headers rsh
3096: WHERE rs.item_id = p_item_id
3097: -- AND Nvl(rs.item_revision,nvl(p_revision,'@@@@')) = nvl(p_revision,'@@@@') --BUG13562127