APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_ITEM_TREE

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

842: CASE inv_mwb_globals.g_tree_node_type
843:
844: WHEN 'APPTREE_OBJECT_TRUNK' THEN
845:
846: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
847: add_qf_where_onhand('ONHAND');
848:
849: WHEN 'ORG' THEN
850:

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

847: add_qf_where_onhand('ONHAND');
848:
849: WHEN 'ORG' THEN
850:
851: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
852:
853: SELECT revision_qty_control_code,
854: lot_control_code,
855: serial_number_control_code

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

893: add_qf_where_onhand('ONHAND');
894:
895: WHEN 'ITEM' THEN
896:
897: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
898: inv_mwb_query_manager.add_where_clause(
899: 'moqd.inventory_item_id = :onh_tree_inventory_item_id' ,
900: 'ONHAND'
901: );

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

914: FROM mtl_system_items
915: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
916: AND organization_id = inv_mwb_globals.g_tree_organization_id;
917:
918: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
919:
920: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
921: 'moqd.revision';
922: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');

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

953: FROM mtl_system_items
954: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
955: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
956:
957: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
958:
959: IF l_rev_control = 2 THEN
960: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.revision).column_value :=
961: 'moqd.revision';

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

979:
980: add_qf_where_onhand('ONHAND');
981: WHEN 'SERIAL' THEN
982: -- Dummy code
983: INV_MWB_ITEM_TREE.make_common_queries('MOQD');
984: add_qf_where_onhand('ONHAND');
985: END CASE;
986:
987: l_query_str := l_query_str || build_query(