APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 229: JAI_CMN_INVENTORY_ORGS org

225:
226: SELECT count(*)
227: into cnt_rec
228: FROM JAI_CMN_RG_PLA_HDRS jibh,
229: JAI_CMN_INVENTORY_ORGS org
230: WHERE jibh.PLA_ID = P_PLA_ID
231: AND org.organization_id = jibh.organization_id
232: AND org.location_id = jibh.location_id;
233:

Line 280: JAI_CMN_INVENTORY_ORGS org

276: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
277: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
278: NULL -- LAST_UPDATE_LOGIN
279: FROM JAI_CMN_RG_PLA_HDRS jibh,
280: JAI_CMN_INVENTORY_ORGS org
281: WHERE jibh.PLA_ID = P_PLA_ID
282: AND org.organization_id = jibh.organization_id
283: AND org.location_id = 0 ;
284:

Line 323: JAI_CMN_INVENTORY_ORGS org

319: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
320: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
321: NULL -- LAST_UPDATE_LOGIN
322: FROM JAI_CMN_RG_PLA_HDRS jibh,
323: JAI_CMN_INVENTORY_ORGS org
324: WHERE jibh.PLA_ID = P_PLA_ID
325: AND org.organization_id = jibh.organization_id
326: AND org.location_id = jibh.location_id;
327:

Line 521: JAI_CMN_INVENTORY_ORGS org

517:
518: select count(*)
519: into cnt_rec
520: from JAI_CMN_BOE_HDRS jibh,
521: JAI_CMN_INVENTORY_ORGS org
522: where jibh.boe_id = p_boe_id
523: and org.organization_id = jibh.organization_id
524: and org.location_id = jibh.location_id;
525:

Line 569: JAI_CMN_INVENTORY_ORGS org

565: jibh.last_updated_by,
566: jibh.last_update_date,
567: null -- last_update_login
568: from JAI_CMN_BOE_HDRS jibh,
569: JAI_CMN_INVENTORY_ORGS org
570: where jibh.boe_id = p_boe_id
571: and org.organization_id = jibh.organization_id
572: AND org.location_id = 0 ;
573:

Line 614: JAI_CMN_INVENTORY_ORGS org

610: jibh.last_update_date,
611: null -- last_update_login
612: from
613: JAI_CMN_BOE_HDRS jibh,
614: JAI_CMN_INVENTORY_ORGS org
615: where
616: jibh.boe_id = p_boe_id
617: and org.organization_id = jibh.organization_id
618: and org.location_id = jibh.location_id;