DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 2419: from MTL_SYSTEM_ITEMS_B

2415:
2416: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
2417: IS
2418: select primary_uom_code
2419: from MTL_SYSTEM_ITEMS_B
2420: where inventory_item_id = l_inventory_item_id
2421: and organization_id = l_org_id
2422: and enabled_flag = 'Y';
2423:

Line 4110: from MTL_SYSTEM_ITEMS_B

4106:
4107: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
4108: IS
4109: select primary_uom_code
4110: from MTL_SYSTEM_ITEMS_B
4111: where inventory_item_id = l_inventory_item_id
4112: and organization_id = l_org_id
4113: and enabled_flag = 'Y';
4114:

Line 4351: from MTL_SYSTEM_ITEMS_B

4347:
4348: CURSOR c_primary_uom (l_inventory_item_id NUMBER,l_org_id NUMBER)
4349: IS
4350: select primary_uom_code
4351: from MTL_SYSTEM_ITEMS_B
4352: where inventory_item_id = l_inventory_item_id
4353: and organization_id = l_org_id
4354: and enabled_flag = 'Y';
4355: