APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_LOT_TREE

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

1063: CASE inv_mwb_globals.g_tree_node_type
1064:
1065: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1066:
1067: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1068: add_qf_where_onhand('ONHAND');
1069:
1070: WHEN 'ORG' THEN
1071:

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

1068: add_qf_where_onhand('ONHAND');
1069:
1070: WHEN 'ORG' THEN
1071:
1072: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1073:
1074: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1075: 'moqd.lot_number';
1076: inv_mwb_query_manager.add_where_clause(

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

1097: FROM mtl_system_items
1098: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
1099: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1100:
1101: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1102:
1103: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1104: 'moqd.lot_number';
1105: IF l_rev_control = 2 THEN

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

1146: null;
1147:
1148: WHEN 'LOT' THEN
1149:
1150: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1151:
1152: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
1153: 'moqd.lot_number';
1154: inv_mwb_query_manager.add_where_clause(

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

1175: add_qf_where_onhand('ONHAND');
1176:
1177: WHEN 'SERIAL' THEN
1178: -- Dummy code
1179: INV_MWB_LOT_TREE.make_common_queries('MOQD');
1180: add_qf_where_onhand('ONHAND');
1181: END CASE;
1182:
1183: l_query_str := l_query_str || build_query(