APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_TRANSACTIONS_INTERFACE

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 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 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 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 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 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 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(