APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_LOT_TREE

Line 1103: INV_MWB_LOT_TREE.make_common_queries('MOQD');

1099: CASE inv_mwb_globals.g_tree_node_type
1100:
1101: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1102:
1103: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1104: add_qf_where_onhand('ONHAND');
1105:
1106: WHEN 'ORG' THEN
1107:

Line 1108: INV_MWB_LOT_TREE.make_common_queries('MOQD');

1104: add_qf_where_onhand('ONHAND');
1105:
1106: WHEN 'ORG' THEN
1107:
1108: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1109:
1110: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1111: 'moqd.lot_number';
1112: inv_mwb_query_manager.add_where_clause(

Line 1137: INV_MWB_LOT_TREE.make_common_queries('MOQD');

1133: FROM mtl_system_items
1134: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
1135: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1136:
1137: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1138:
1139: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1140: 'moqd.lot_number';
1141: IF l_rev_control = 2 THEN

Line 1186: INV_MWB_LOT_TREE.make_common_queries('MOQD');

1182: null;
1183:
1184: WHEN 'LOT' THEN
1185:
1186: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1187:
1188: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1189: 'moqd.lot_number';
1190: inv_mwb_query_manager.add_where_clause(

Line 1215: INV_MWB_LOT_TREE.make_common_queries('MOQD');

1211: add_qf_where_onhand('ONHAND');
1212:
1213: WHEN 'SERIAL' THEN
1214: -- Dummy code
1215: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1216: add_qf_where_onhand('ONHAND');
1217: END CASE;
1218:
1219: l_query_str := l_query_str || build_query(