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 504: -- removed rcv_transactions_interface_sv.check_date_tolerance;

500: asn_debug.put_line('cursor record ' || TO_CHAR(rows_fetched));
501: asn_debug.put_line('int org rcv : calling get available qty');
502: END IF;
503:
504: -- removed rcv_transactions_interface_sv.check_date_tolerance;
505: -- removed check shipto_location enforcement
506: -- removed check receipt days exception code
507:
508: --{

Line 1203: FROM rcv_transactions rt,

1199: rt.deliver_to_person_id,
1200: rt.deliver_to_location_id,
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

Line 1239: FROM rcv_transactions_interface rti

1235: rti.deliver_to_person_id,
1236: rti.deliver_to_location_id,
1237: rti.subinventory,
1238: rti.transfer_lpn_id
1239: FROM rcv_transactions_interface rti
1240: WHERE interface_transaction_id = v_parent_inter_trx_id;
1241:
1242: default_int_org_transfer_info int_org_transfer%ROWTYPE;
1243: x_progress VARCHAR2(3);

Line 1533: rcv_transactions rt,

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

Line 1564: FROM rcv_transactions_interface rti

1560: rti.destination_type_code,
1561: rti.to_organization_id destination_organization_id,
1562: rti.quantity qty,
1563: rti.interface_available_qty
1564: FROM rcv_transactions_interface rti
1565: WHERE interface_transaction_id = v_parent_inter_trx_id;
1566:
1567: x_int_org_transferrec int_org_transfer%ROWTYPE;
1568: x_temp_parent_trx_qty NUMBER := 0;

Line 1580: l_transaction_type rcv_transactions.transaction_type%TYPE;

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);
1584: END IF;

Line 1867: FROM rcv_transactions rt,

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

Line 2294: FROM rcv_transactions rt,

2290: rt.subinventory destination_subinventory,
2291: rt.destination_type_code,
2292: rsl.ussgl_transaction_code,
2293: rt.oe_order_line_id
2294: FROM rcv_transactions rt,
2295: rcv_shipment_lines rsl
2296: WHERE rt.transaction_id = v_parent_trx_id
2297: AND rt.shipment_line_id = rsl.shipment_line_id
2298: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 2326: FROM rcv_transactions_interface rti

2322: rti.subinventory destination_subinventory,
2323: rti.destination_type_code,
2324: rti.ussgl_transaction_code,
2325: rti.oe_order_line_id
2326: FROM rcv_transactions_interface rti
2327: WHERE interface_transaction_id = v_parent_interface_txn_id
2328: AND rti.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'RETURN TO CUSTOMER');
2329:
2330: int_org_cor_rec int_org_cor_rt%ROWTYPE;

Line 2334: l_transaction_type rcv_transactions.transaction_type%TYPE;

2330: int_org_cor_rec int_org_cor_rt%ROWTYPE;
2331: x_converted_parent_trx_qty NUMBER := 0;
2332: -- x_remaining_qty_parent_uom NUMBER := 0;
2333: l_to_organization_id NUMBER := 0;
2334: l_transaction_type rcv_transactions.transaction_type%TYPE;
2335: x_temp_already_allocated_qty NUMBER := 0;
2336: derive_values_from_table BOOLEAN := FALSE;
2337: derive_values_from_rti BOOLEAN := FALSE;
2338: already_derived BOOLEAN := FALSE;

Line 2339: l_grand_parent_trx_id rcv_transactions.parent_transaction_id%TYPE;

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

Line 2344: l_primary_uom rcv_transactions_interface.unit_of_measure%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;
2346: l_interface_quantity NUMBER;
2347: l_interface_qty_in_trx_uom NUMBER;
2348: l_item_id NUMBER;

Line 2345: l_transaction_uom rcv_transactions.unit_of_measure%TYPE;

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;
2346: l_interface_quantity NUMBER;
2347: l_interface_qty_in_trx_uom NUMBER;
2348: l_item_id NUMBER;
2349: /* Bug#5369121 */

Line 2369: FROM rcv_transactions

2365: */
2366: BEGIN
2367: SELECT transaction_id
2368: INTO x_cascaded_table(n).parent_transaction_id
2369: FROM rcv_transactions
2370: WHERE source_transaction_num = x_cascaded_table(n).parent_source_transaction_num;
2371:
2372: already_derived := TRUE;
2373: EXCEPTION

Line 2665: FROM rcv_transactions rt,

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

Line 2776: FROM rcv_transactions rt,

2772: rt.primary_unit_of_measure
2773: INTO l_transaction_uom,
2774: l_item_id,
2775: l_primary_uom
2776: FROM rcv_transactions rt,
2777: rcv_shipment_lines rsl
2778: WHERE rsl.shipment_line_id = rt.shipment_line_id
2779: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2780:

Line 2783: FROM rcv_transactions_interface

2779: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2780:
2781: SELECT NVL(SUM(interface_transaction_qty),0)
2782: INTO l_interface_quantity
2783: FROM rcv_transactions_interface
2784: WHERE (transaction_status_code = 'PENDING'
2785: AND processing_status_code <> 'ERROR')
2786: AND group_id = temp_cascaded_table(current_n).group_id
2787: AND transaction_type = 'CORRECT'

Line 2789: FROM rcv_transactions

2785: AND processing_status_code <> 'ERROR')
2786: AND group_id = temp_cascaded_table(current_n).group_id
2787: AND transaction_type = 'CORRECT'
2788: AND parent_transaction_id IN ( SELECT transaction_id
2789: FROM rcv_transactions
2790: WHERE parent_transaction_id = int_org_cor_rec.rcv_transaction_id);
2791:
2792: IF (l_interface_quantity = 0) THEN
2793:

Line 3066: FROM rcv_transactions rt,

3062: rt.subinventory,
3063: rt.lpn_id,
3064: rt.transfer_lpn_id,
3065: rt.transaction_type
3066: FROM rcv_transactions rt,
3067: rcv_shipment_lines rsl
3068: WHERE rt.transaction_id = v_parent_trx_id
3069: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT')
3070: AND rt.shipment_line_id = rsl.shipment_line_id

Line 3097: FROM rcv_transactions_interface rti

3093: rti.subinventory,
3094: rti.lpn_id,
3095: rti.transfer_lpn_id,
3096: rti.transaction_type
3097: FROM rcv_transactions_interface rti
3098: WHERE interface_transaction_id = v_parent_inter_trx_id;
3099:
3100: --bug 3704623
3101: CURSOR int_org_cor_rsl(