eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_TRANSACTIONS

Line 515: -- removed rcv_transactions_interface_sv.check_date_tolerance;

511: asn_debug.put_line('cursor record ' || TO_CHAR(rows_fetched));
512: asn_debug.put_line('int org rcv : calling get available qty');
513: END IF;
514:
515: -- removed rcv_transactions_interface_sv.check_date_tolerance;
516: -- removed check shipto_location enforcement
517: -- removed check receipt days exception code
518:
519: --{

Line 1246: FROM rcv_transactions rt,

1242: rt.deliver_to_person_id,
1243: rt.deliver_to_location_id,
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

Line 1282: FROM rcv_transactions_interface rti

1278: rti.deliver_to_person_id,
1279: rti.deliver_to_location_id,
1280: rti.subinventory,
1281: rti.transfer_lpn_id
1282: FROM rcv_transactions_interface rti
1283: WHERE interface_transaction_id = v_parent_inter_trx_id;
1284:
1285: default_int_org_transfer_info int_org_transfer%ROWTYPE;
1286: x_progress VARCHAR2(3);

Line 1576: rcv_transactions rt,

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)
1580: AND rsup.supply_type_code = 'RECEIVING'

Line 1607: FROM rcv_transactions_interface rti

1603: rti.destination_type_code,
1604: rti.to_organization_id destination_organization_id,
1605: rti.quantity qty,
1606: rti.interface_available_qty
1607: FROM rcv_transactions_interface rti
1608: WHERE interface_transaction_id = v_parent_inter_trx_id;
1609:
1610: x_int_org_transferrec int_org_transfer%ROWTYPE;
1611: x_temp_parent_trx_qty NUMBER := 0;

Line 1623: l_transaction_type rcv_transactions.transaction_type%TYPE;

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;
1627: --Bug 8631613

Line 1914: FROM rcv_transactions rt,

1910: SELECT MAX(rsup.supply_type_code),
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:

Line 2369: FROM rcv_transactions rt,

2365: rt.subinventory destination_subinventory,
2366: rt.destination_type_code,
2367: rsl.ussgl_transaction_code,
2368: rt.oe_order_line_id
2369: FROM rcv_transactions rt,
2370: rcv_shipment_lines rsl
2371: WHERE rt.transaction_id = v_parent_trx_id
2372: AND rt.shipment_line_id = rsl.shipment_line_id
2373: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 2401: FROM rcv_transactions_interface rti

2397: rti.subinventory destination_subinventory,
2398: rti.destination_type_code,
2399: rti.ussgl_transaction_code,
2400: rti.oe_order_line_id
2401: FROM rcv_transactions_interface rti
2402: WHERE interface_transaction_id = v_parent_interface_txn_id
2403: AND rti.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'RETURN TO CUSTOMER');
2404:
2405: int_org_cor_rec int_org_cor_rt%ROWTYPE;

Line 2409: l_transaction_type rcv_transactions.transaction_type%TYPE;

2405: int_org_cor_rec int_org_cor_rt%ROWTYPE;
2406: x_converted_parent_trx_qty NUMBER := 0;
2407: -- x_remaining_qty_parent_uom NUMBER := 0;
2408: l_to_organization_id NUMBER := 0;
2409: l_transaction_type rcv_transactions.transaction_type%TYPE;
2410: x_temp_already_allocated_qty NUMBER := 0;
2411: derive_values_from_table BOOLEAN := FALSE;
2412: derive_values_from_rti BOOLEAN := FALSE;
2413: already_derived BOOLEAN := FALSE;

Line 2414: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;

2410: x_temp_already_allocated_qty NUMBER := 0;
2411: derive_values_from_table BOOLEAN := FALSE;
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 */

Line 2419: l_primary_uom rcv_transactions_interface.unit_of_measure%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;
2421: l_interface_quantity NUMBER;
2422: l_interface_qty_in_trx_uom NUMBER;
2423: l_item_id NUMBER;

Line 2420: l_transaction_uom rcv_transactions.unit_of_measure%TYPE;

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;
2421: l_interface_quantity NUMBER;
2422: l_interface_qty_in_trx_uom NUMBER;
2423: l_item_id NUMBER;
2424: /* Bug#5369121 */

Line 2444: FROM rcv_transactions

2440: */
2441: BEGIN
2442: SELECT transaction_id
2443: INTO x_cascaded_table(n).parent_transaction_id
2444: FROM rcv_transactions
2445: WHERE source_transaction_num = x_cascaded_table(n).parent_source_transaction_num;
2446:
2447: already_derived := TRUE;
2448: EXCEPTION

Line 2740: FROM rcv_transactions rt,

2736: SELECT MAX(rsup.supply_type_code),
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:

Line 2851: FROM rcv_transactions rt,

2847: rt.primary_unit_of_measure
2848: INTO l_transaction_uom,
2849: l_item_id,
2850: l_primary_uom
2851: FROM rcv_transactions rt,
2852: rcv_shipment_lines rsl
2853: WHERE rsl.shipment_line_id = rt.shipment_line_id
2854: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2855:

Line 2858: FROM rcv_transactions_interface

2854: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2855:
2856: SELECT NVL(SUM(interface_transaction_qty),0)
2857: INTO l_interface_quantity
2858: FROM rcv_transactions_interface
2859: WHERE (transaction_status_code = 'PENDING'
2860: AND processing_status_code <> 'ERROR')
2861: AND group_id = temp_cascaded_table(current_n).group_id
2862: AND transaction_type = 'CORRECT'

Line 2864: FROM rcv_transactions

2860: AND processing_status_code <> 'ERROR')
2861: AND group_id = temp_cascaded_table(current_n).group_id
2862: AND transaction_type = 'CORRECT'
2863: AND parent_transaction_id IN ( SELECT transaction_id
2864: FROM rcv_transactions
2865: WHERE parent_transaction_id = int_org_cor_rec.rcv_transaction_id);
2866:
2867: IF (l_interface_quantity = 0) THEN
2868:

Line 3141: FROM rcv_transactions rt,

3137: rt.subinventory,
3138: rt.lpn_id,
3139: rt.transfer_lpn_id,
3140: rt.transaction_type
3141: FROM rcv_transactions rt,
3142: rcv_shipment_lines rsl
3143: WHERE rt.transaction_id = v_parent_trx_id
3144: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT')
3145: AND rt.shipment_line_id = rsl.shipment_line_id

Line 3172: FROM rcv_transactions_interface rti

3168: rti.subinventory,
3169: rti.lpn_id,
3170: rti.transfer_lpn_id,
3171: rti.transaction_type
3172: FROM rcv_transactions_interface rti
3173: WHERE interface_transaction_id = v_parent_inter_trx_id;
3174:
3175: --bug 3704623
3176: CURSOR int_org_cor_rsl(