APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_TRANSACTIONS_INTERFACE

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