DBA Data[Home] [Help]

APPS.INV_MWB_QUERY_MANAGER dependencies on INV_MWB_COST_GROUP_TREE

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

1038: CASE inv_mwb_globals.g_tree_node_type
1039:
1040: WHEN 'APPTREE_OBJECT_TRUNK' THEN
1041:
1042: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1043: add_qf_where_onhand('ONHAND');
1044:
1045: WHEN 'COST_GROUP' THEN
1046:

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

1043: add_qf_where_onhand('ONHAND');
1044:
1045: WHEN 'COST_GROUP' THEN
1046:
1047: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1048:
1049: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1050: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);
1051:

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

1052: add_qf_where_onhand('ONHAND');
1053:
1054: WHEN 'ORG' THEN
1055:
1056: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1057:
1058: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1059: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1060: inv_mwb_query_manager.add_bind_variable('onh_tree_cost_group_id', inv_mwb_globals.g_tree_cg_id);

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

1063: add_qf_where_onhand('ONHAND');
1064:
1065: WHEN 'ITEM' THEN
1066:
1067: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1068:
1069: inv_mwb_query_manager.add_where_clause('moqd.cost_group_id = :onh_tree_cost_group_id' ,'ONHAND');
1070: inv_mwb_query_manager.add_where_clause('moqd.organization_id = :onh_tree_organization_id' ,'ONHAND');
1071: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = :onh_tree_inventory_item_id' ,'ONHAND');

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

1076: add_qf_where_onhand('ONHAND');
1077:
1078: WHEN 'SERIAL' THEN
1079: -- Dummy code
1080: INV_MWB_COST_GROUP_TREE.make_common_queries('MOQD');
1081: add_qf_where_onhand('ONHAND');
1082: END CASE;
1083:
1084: l_query_str := l_query_str || build_query(