APPS.INV_MWB_TREE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 5928: item mtl_system_items_kfv.concatenated_segments%TYPE;

5924: rows_processed NUMBER;
5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;
5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
5928: item mtl_system_items_kfv.concatenated_segments%TYPE;
5929: i NUMBER := x_tbl_index;
5930: j NUMBER := x_node_value;
5931: is_bind_required BOOLEAN := TRUE;
5932: table_required VARCHAR2(200);

Line 6616: FROM mtl_system_items_kfv

6612: IF item_id IS NOT NULL
6613: AND item_id <> 0 THEN
6614: SELECT concatenated_segments
6615: INTO item
6616: FROM mtl_system_items_kfv
6617: WHERE organization_id = p_organization_id
6618: AND inventory_item_id = item_id;
6619:
6620: item := ' (' || item || ')';

Line 6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;

6705: ) IS
6706: query_str VARCHAR2(10000);
6707: query_hdl NUMBER;
6708: rows_processed NUMBER;
6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
6710: item mtl_system_items_kfv.concatenated_segments%TYPE;
6711: i NUMBER := x_tbl_index;
6712: j NUMBER := x_node_value;
6713: table_required VARCHAR2(300);

Line 6710: item mtl_system_items_kfv.concatenated_segments%TYPE;

6706: query_str VARCHAR2(10000);
6707: query_hdl NUMBER;
6708: rows_processed NUMBER;
6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
6710: item mtl_system_items_kfv.concatenated_segments%TYPE;
6711: i NUMBER := x_tbl_index;
6712: j NUMBER := x_node_value;
6713: table_required VARCHAR2(300);
6714:

Line 8180: item mtl_system_items_kfv.concatenated_segments%TYPE;

8176: ) IS
8177: query_str VARCHAR2(10000);
8178: query_hdl NUMBER;
8179: rows_processed NUMBER;
8180: item mtl_system_items_kfv.concatenated_segments%TYPE;
8181: rev mtl_onhand_quantities.revision%TYPE;
8182: rev_control NUMBER;
8183: i NUMBER := x_tbl_index;
8184: j NUMBER := x_node_value;