DBA Data[Home] [Help]

APPS.INV_MWB_TREE dependencies on MTL_ONHAND_QUANTITIES

Line 74: org_id mtl_onhand_quantities.organization_id%TYPE;

70: ) IS
71: query_str VARCHAR2(10000);
72: query_hdl NUMBER;
73: rows_processed NUMBER;
74: org_id mtl_onhand_quantities.organization_id%TYPE;
75: org_code mtl_parameters.organization_code%TYPE;
76: i NUMBER := x_tbl_index;
77: j NUMBER := x_node_value;
78: table_required VARCHAR2(300);

Line 2677: sub_code mtl_onhand_quantities.subinventory_code%TYPE;

2673: ) IS
2674: query_str VARCHAR2(10000);
2675: query_hdl NUMBER;
2676: rows_processed NUMBER;
2677: sub_code mtl_onhand_quantities.subinventory_code%TYPE;
2678: i NUMBER := x_tbl_index;
2679: j NUMBER := x_node_value;
2680: table_required VARCHAR2(300);
2681: is_grade_t BOOLEAN DEFAULT FALSE ; -- NSRIVAST, INVCONV

Line 8181: rev mtl_onhand_quantities.revision%TYPE;

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;
8185: table_required VARCHAR2(300);

Line 9327: lot mtl_onhand_quantities.lot_number%TYPE;

9323: ) IS
9324: query_str VARCHAR2(10000);
9325: query_hdl NUMBER;
9326: rows_processed NUMBER;
9327: lot mtl_onhand_quantities.lot_number%TYPE;
9328: lot_control NUMBER;
9329: i NUMBER := x_tbl_index;
9330: j NUMBER := x_node_value;
9331: table_required VARCHAR2(300);

Line 11163: org_id mtl_onhand_quantities.organization_id%TYPE;

11159:
11160: query_str VARCHAR2(10000);
11161: query_hdl NUMBER;
11162: rows_processed NUMBER;
11163: org_id mtl_onhand_quantities.organization_id%TYPE;
11164: org_code mtl_parameters.organization_code%TYPE;
11165: i NUMBER := x_tbl_index;
11166: j NUMBER := x_node_value;
11167: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;