DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 273: FROM jai_cmn_inventory_orgs

269: AND organization_id = pn_chk_organization_id;
270:
271: CURSOR chk_loc_cur IS
272: SELECT COUNT(location_id)
273: FROM jai_cmn_inventory_orgs
274: WHERE organization_id = pn_chk_organization_id
275: AND location_id = pn_chk_location_id;
276:
277: CURSOR chk_combination_cur IS

Line 279: FROM jai_cmn_inventory_orgs a

275: AND location_id = pn_chk_location_id;
276:
277: CURSOR chk_combination_cur IS
278: SELECT COUNT(b.organization_id)
279: FROM jai_cmn_inventory_orgs a
280: , org_organization_definitions b
281: WHERE b.operating_unit = pn_chk_org_id
282: AND a.organization_id = pn_chk_organization_id
283: AND a.location_id = pn_chk_location_id