DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2476: from MTL_SYSTEM_ITEMS_B

2472:
2473: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
2474: IS
2475: select primary_uom_code
2476: from MTL_SYSTEM_ITEMS_B
2477: where inventory_item_id = l_inventory_item_id
2478: and organization_id = l_org_id
2479: and enabled_flag = 'Y';
2480:

Line 4173: from MTL_SYSTEM_ITEMS_B

4169:
4170: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
4171: IS
4172: select primary_uom_code
4173: from MTL_SYSTEM_ITEMS_B
4174: where inventory_item_id = l_inventory_item_id
4175: and organization_id = l_org_id
4176: and enabled_flag = 'Y';
4177:

Line 4414: from MTL_SYSTEM_ITEMS_B

4410:
4411: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
4412: IS
4413: select primary_uom_code
4414: from MTL_SYSTEM_ITEMS_B
4415: where inventory_item_id = l_inventory_item_id
4416: and organization_id = l_org_id
4417: and enabled_flag = 'Y';
4418: