APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_ITEM_TREE

Line 882: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

878: CASE inv_mwb_globals.g_tree_node_type
879:
880: WHEN 'APPTREE_OBJECT_TRUNK' THEN
881:
882: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
883: add_qf_where_onhand('ONHAND');
884:
885: WHEN 'ORG' THEN
886:

Line 887: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

883: add_qf_where_onhand('ONHAND');
884:
885: WHEN 'ORG' THEN
886:
887: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
888:
889: SELECT revision_qty_control_code,
890: lot_control_code,
891: serial_number_control_code

Line 933: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

929: add_qf_where_onhand('ONHAND');
930:
931: WHEN 'ITEM' THEN
932:
933: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
934: inv_mwb_query_manager.add_where_clause(
935: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
936: 'ONHAND'
937: );

Line 954: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

950: FROM mtl_system_items
951: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
952: AND organization_id = inv_mwb_globals.g_tree_organization_id;
953:
954: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
955:
956: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
957: 'moqd.revision';
958: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

Line 993: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

989: FROM mtl_system_items
990: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
991: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
992:
993: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
994:
995: IF l_rev_control = 2 THEN
996: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
997: 'moqd.revision';

Line 1019: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

1015:
1016: add_qf_where_onhand('ONHAND');
1017: WHEN 'SERIAL' THEN
1018: -- Dummy code
1019: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
1020: add_qf_where_onhand('ONHAND');
1021: END CASE;
1022:
1023: l_query_str := l_query_str || build_query(