APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SUPPLY

Line 1248: rcv_supply rsup

1244: rt.subinventory,
1245: rt.transfer_lpn_id
1246: FROM rcv_transactions rt,
1247: rcv_shipment_lines rsl,
1248: rcv_supply rsup
1249: WHERE rt.transaction_id = v_parent_trx_id
1250: AND rt.transaction_id = rsup.rcv_transaction_id
1251: AND rsup.supply_type_code = 'RECEIVING'
1252: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 1575: FROM rcv_supply rsup,

1571: rt.destination_type_code,
1572: rt.organization_id destination_organization_id, --pod.destination_organization_id,
1573: rt.quantity qty,
1574: 0 interface_available_qty
1575: FROM rcv_supply rsup,
1576: rcv_transactions rt,
1577: rcv_shipment_lines rsl
1578: WHERE rt.transaction_id = v_parent_trx_id
1579: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)

Line 1622: l_supply_code rcv_supply.supply_type_code%TYPE;

1618: derive_values_from_rti BOOLEAN := FALSE;
1619: already_derived BOOLEAN := FALSE;
1620: cascaded_table_index NUMBER;
1621: temp_index NUMBER;
1622: l_supply_code rcv_supply.supply_type_code%TYPE;
1623: l_transaction_type rcv_transactions.transaction_type%TYPE;
1624: --Bug 8631613
1625: l_temp_qty NUMBER;
1626: l_pri_temp_qty NUMBER;

Line 1915: rcv_supply rsup

1911: MAX(rt.transaction_type)
1912: INTO l_supply_code,
1913: l_transaction_type
1914: FROM rcv_transactions rt,
1915: rcv_supply rsup
1916: WHERE rt.transaction_id = temp_cascaded_table(current_n).parent_transaction_id
1917: AND rsup.rcv_transaction_id = rt.transaction_id;
1918:
1919: IF l_supply_code <> 'RECEIVING' THEN

Line 2416: l_supply_code rcv_supply.supply_type_code%TYPE;

2412: derive_values_from_rti BOOLEAN := FALSE;
2413: already_derived BOOLEAN := FALSE;
2414: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;
2415: temp_index NUMBER;
2416: l_supply_code rcv_supply.supply_type_code%TYPE;
2417:
2418: /* Bug#5369121 */
2419: l_primary_uom rcv_transactions_interface.unit_of_measure%TYPE;
2420: l_transaction_uom rcv_transactions.unit_of_measure%TYPE;

Line 2741: rcv_supply rsup

2737: MAX(rt.transaction_type)
2738: INTO l_supply_code,
2739: l_transaction_type
2740: FROM rcv_transactions rt,
2741: rcv_supply rsup
2742: WHERE rt.transaction_id = temp_cascaded_table(current_n).parent_transaction_id
2743: AND rsup.rcv_transaction_id = rt.transaction_id;
2744:
2745: IF l_supply_code <> 'RECEIVING' THEN