DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_COST_GROUP_TREE

Line 1006: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');

1002: CASE inv_mwb_globals.g_tree_node_type
1003:
1004: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1005:
1006: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1007: add_qf_where_onhand('ONHAND');
1008:
1009: WHEN 'COST_GROUP' THEN
1010:

Line 1011: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');

1007: add_qf_where_onhand('ONHAND');
1008:
1009: WHEN 'COST_GROUP' THEN
1010:
1011: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1012:
1013: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1014: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1015:

Line 1020: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');

1016: add_qf_where_onhand('ONHAND');
1017:
1018: WHEN 'ORG' THEN
1019:
1020: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1021:
1022: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1023: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1024: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

Line 1031: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');

1027: add_qf_where_onhand('ONHAND');
1028:
1029: WHEN 'ITEM' THEN
1030:
1031: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1032:
1033: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1034: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1035: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

Line 1044: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');

1040: add_qf_where_onhand('ONHAND');
1041:
1042: WHEN 'SERIAL' THEN
1043: -- Dummy code
1044: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1045: add_qf_where_onhand('ONHAND');
1046: END CASE;
1047:
1048: l_query_str := l_query_str || build_query(