DBA Data[Home] [Help]

APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SUPPLY

Line 1205: rcv_supply rsup

1201: rt.subinventory,
1202: rt.transfer_lpn_id
1203: FROM rcv_transactions rt,
1204: rcv_shipment_lines rsl,
1205: rcv_supply rsup
1206: WHERE rt.transaction_id = v_parent_trx_id
1207: AND rt.transaction_id = rsup.rcv_transaction_id
1208: AND rsup.supply_type_code = 'RECEIVING'
1209: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 1532: FROM rcv_supply rsup,

1528: rt.destination_type_code,
1529: rt.organization_id destination_organization_id, --pod.destination_organization_id,
1530: rt.quantity qty,
1531: 0 interface_available_qty
1532: FROM rcv_supply rsup,
1533: rcv_transactions rt,
1534: rcv_shipment_lines rsl
1535: WHERE rt.transaction_id = v_parent_trx_id
1536: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)

Line 1579: l_supply_code rcv_supply.supply_type_code%TYPE;

1575: derive_values_from_rti BOOLEAN := FALSE;
1576: already_derived BOOLEAN := FALSE;
1577: cascaded_table_index NUMBER;
1578: temp_index NUMBER;
1579: l_supply_code rcv_supply.supply_type_code%TYPE;
1580: l_transaction_type rcv_transactions.transaction_type%TYPE;
1581: BEGIN
1582: IF (g_asn_debug = 'Y') THEN
1583: asn_debug.put_line('enter derive_quantity ' || x_cascaded_table(n).parent_transaction_id);

Line 1868: rcv_supply rsup

1864: MAX(rt.transaction_type)
1865: INTO l_supply_code,
1866: l_transaction_type
1867: FROM rcv_transactions rt,
1868: rcv_supply rsup
1869: WHERE rt.transaction_id = temp_cascaded_table(current_n).parent_transaction_id
1870: AND rsup.rcv_transaction_id = rt.transaction_id;
1871:
1872: IF l_supply_code <> 'RECEIVING' THEN

Line 2341: l_supply_code rcv_supply.supply_type_code%TYPE;

2337: derive_values_from_rti BOOLEAN := FALSE;
2338: already_derived BOOLEAN := FALSE;
2339: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;
2340: temp_index NUMBER;
2341: l_supply_code rcv_supply.supply_type_code%TYPE;
2342:
2343: /* Bug#5369121 */
2344: l_primary_uom rcv_transactions_interface.unit_of_measure%TYPE;
2345: l_transaction_uom rcv_transactions.unit_of_measure%TYPE;

Line 2666: rcv_supply rsup

2662: MAX(rt.transaction_type)
2663: INTO l_supply_code,
2664: l_transaction_type
2665: FROM rcv_transactions rt,
2666: rcv_supply rsup
2667: WHERE rt.transaction_id = temp_cascaded_table(current_n).parent_transaction_id
2668: AND rsup.rcv_transaction_id = rt.transaction_id;
2669:
2670: IF l_supply_code <> 'RECEIVING' THEN