APPS.INV_MWB_TREE dependencies on MTL_MATERIAL_STATUSES_VL

Line 1582: status_id mtl_material_statuses_vl.status_id%TYPE;

1578: ) IS
1579: query_str VARCHAR2(10000);
1580: query_hdl NUMBER;
1581: rows_processed NUMBER;
1582: status_id mtl_material_statuses_vl.status_id%TYPE;
1583: status_code mtl_material_statuses_vl.status_code%TYPE;
1584: i NUMBER := x_tbl_index;
1585: j NUMBER := x_node_value;
1586: serial_control NUMBER;

Line 1583: status_code mtl_material_statuses_vl.status_code%TYPE;

1579: query_str VARCHAR2(10000);
1580: query_hdl NUMBER;
1581: rows_processed NUMBER;
1582: status_id mtl_material_statuses_vl.status_id%TYPE;
1583: status_code mtl_material_statuses_vl.status_code%TYPE;
1584: i NUMBER := x_tbl_index;
1585: j NUMBER := x_node_value;
1586: serial_control NUMBER;
1587: table_required VARCHAR2(300);

Line 1605: query_str := query_str || 'FROM mtl_material_statuses_vl mms ';

1601: END IF ;
1602: -- NSRIVAST, INVCONV, End
1603:
1604: query_str := 'SELECT mms.status_id, mms.status_code ';
1605: query_str := query_str || 'FROM mtl_material_statuses_vl mms ';
1606: query_str := query_str || ' WHERE exists (';
1607:
1608: IF p_organization_id IS NOT NULL
1609: AND p_inventory_item_id IS NOT NULL THEN