DBA Data[Home] [Help]

APPS.GR_ITEM_PROPERTIES_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 112: FROM mtl_system_items_b_kfv

108: WHERE organization_code = l_organization;
109:
110: cursor c_get_item_id is
111: SELECT inventory_item_id into l_inventory_item_id
112: FROM mtl_system_items_b_kfv
113: WHERE concatenated_segments = l_item
114: AND organization_id = l_organization_id;
115:
116: cursor c_hazardous_material_flag is

Line 118: FROM mtl_system_items_b

114: AND organization_id = l_organization_id;
115:
116: cursor c_hazardous_material_flag is
117: SELECT 1
118: FROM mtl_system_items_b
119: WHERE inventory_item_id = l_inventory_item_id
120: AND organization_id = l_organization_id
121: AND hazardous_material_flag = 'Y';
122: