APPS.INV_MGD_MVT_STATS_PROC dependencies on RCV_SHIPMENT_LINES

Line 2525: , rcv_shipment_lines rsl

2521: FROM
2522: oe_order_lines_all oola
2523: , wsh_delivery_details_ob_grp_v wdd
2524: , rcv_transactions rcv
2525: , rcv_shipment_lines rsl
2526: , mtl_material_transactions mmt
2527: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
2528: AND oola.orig_sys_document_ref = l_req_number
2529: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id

Line 3463: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;

3459: l_par_source_type mtl_movement_statistics.document_source_type%TYPE;
3460: l_update_status VARCHAR2(1);
3461: l_dropship_source_id NUMBER;
3462: l_le_terr_code VARCHAR2(2);
3463: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;
3464: l_subinv_terr_code VARCHAR2(2);
3465: l_org_terr_code VARCHAR2(2);
3466: l_api_name CONSTANT VARCHAR2(30) := 'Process_PO_Transaction';
3467: l_error VARCHAR2(600);

Line 4886: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;

4882: l_return_status VARCHAR2(1);
4883: l_insert_status VARCHAR2(10);
4884: l_movement_id NUMBER;
4885: --l_trans_date DATE;
4886: l_subinv_code RCV_SHIPMENT_LINES.To_Subinventory%TYPE;
4887: l_subinv_terr_code VARCHAR2(2);
4888: l_org_terr_code VARCHAR2(2);
4889: l_rma_le_id NUMBER;
4890: l_receiving_le_id NUMBER;