DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on OKE_SYSTEM_ITEMS_V

Line 96: select 'x' from oke_system_items_v

92: where master_organization_id=b_master_org_id
93: and organization_id=b_inv_org_id;
94:
95: Cursor c_check_item(b_item_id number,b_inv_org_id number) is
96: select 'x' from oke_system_items_v
97: where id1=b_item_id and id2=b_inv_org_id;
98:
99: Cursor c_check_currency(b_currency_code Varchar2) is
100: select 'x' from fnd_currencies

Line 118: select primary_uom_code from oke_system_items_v

114: where end_item_id=b_item_id
115: and unit_number=b_unit_number;
116:
117: Cursor c_get_primary_uom(b_item_id number) is
118: select primary_uom_code from oke_system_items_v
119: where inventory_item_id=b_item_id;
120:
121: l_x varchar2(1);
122: begin