DBA Data[Home] [Help]

APPS.INV_MWB_TREE1 dependencies on MTL_ONHAND_QUANTITIES

Line 1003: org_id mtl_onhand_quantities.organization_id%TYPE;

999: ) IS
1000: query_str VARCHAR2(10000);
1001: query_hdl NUMBER;
1002: rows_processed NUMBER;
1003: org_id mtl_onhand_quantities.organization_id%TYPE;
1004: org_code mtl_parameters.organization_code%TYPE;
1005: i NUMBER := x_tbl_index;
1006: j NUMBER := x_node_value;
1007: table_required VARCHAR2(300);

Line 6193: sub_code mtl_onhand_quantities.subinventory_code%TYPE;

6189: ) IS
6190: query_str VARCHAR2(10000);
6191: query_hdl NUMBER;
6192: rows_processed NUMBER;
6193: sub_code mtl_onhand_quantities.subinventory_code%TYPE;
6194: i NUMBER := x_tbl_index;
6195: j NUMBER := x_node_value;
6196: table_required VARCHAR2(300);
6197: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV

Line 13808: rev mtl_onhand_quantities.revision%TYPE;

13804: query_str VARCHAR2(10000);
13805: query_hdl NUMBER;
13806: rows_processed NUMBER;
13807: item mtl_system_items_kfv.concatenated_segments%TYPE;
13808: rev mtl_onhand_quantities.revision%TYPE;
13809: rev_control NUMBER;
13810: i NUMBER := x_tbl_index;
13811: j NUMBER := x_node_value;
13812: table_required VARCHAR2(300);

Line 15328: lot mtl_onhand_quantities.lot_number%TYPE;

15324: ) IS
15325: query_str VARCHAR2(10000);
15326: query_hdl NUMBER;
15327: rows_processed NUMBER;
15328: lot mtl_onhand_quantities.lot_number%TYPE;
15329: lot_control NUMBER;
15330: serial_control NUMBER;
15331: i NUMBER := x_tbl_index;
15332: j NUMBER := x_node_value;

Line 18022: org_id mtl_onhand_quantities.organization_id%TYPE;

18018:
18019: query_str VARCHAR2(10000);
18020: query_hdl NUMBER;
18021: rows_processed NUMBER;
18022: org_id mtl_onhand_quantities.organization_id%TYPE;
18023: org_code mtl_parameters.organization_code%TYPE;
18024: i NUMBER := x_tbl_index;
18025: j NUMBER := x_node_value;
18026: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;