APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 241: JAI_CMN_INVENTORY_ORGS org

237:
238: SELECT count(*)
239: into cnt_rec
240: FROM JAI_CMN_RG_PLA_HDRS jibh,
241: JAI_CMN_INVENTORY_ORGS org
242: WHERE jibh.PLA_ID = P_PLA_ID
243: AND org.organization_id = jibh.organization_id
244: AND org.location_id = jibh.location_id;
245:

Line 292: JAI_CMN_INVENTORY_ORGS org

288: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
289: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
290: NULL -- LAST_UPDATE_LOGIN
291: FROM JAI_CMN_RG_PLA_HDRS jibh,
292: JAI_CMN_INVENTORY_ORGS org
293: WHERE jibh.PLA_ID = P_PLA_ID
294: AND org.organization_id = jibh.organization_id
295: AND org.location_id = 0 ;
296:

Line 335: JAI_CMN_INVENTORY_ORGS org

331: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
332: jibh.LAST_UPDATE_DATE, -- LAST_UPDATE_DATE,
333: NULL -- LAST_UPDATE_LOGIN
334: FROM JAI_CMN_RG_PLA_HDRS jibh,
335: JAI_CMN_INVENTORY_ORGS org
336: WHERE jibh.PLA_ID = P_PLA_ID
337: AND org.organization_id = jibh.organization_id
338: AND org.location_id = jibh.location_id;
339:

Line 600: JAI_CMN_INVENTORY_ORGS org

596: /* Comment out by Wenqiong Zhou for Bug #1168411 BOE enhancement Begin
597: select count(*)
598: into cnt_rec
599: from JAI_CMN_BOE_HDRS jibh,
600: JAI_CMN_INVENTORY_ORGS org
601: where jibh.boe_id = p_boe_id
602: and org.organization_id = jibh.organization_id
603: and org.location_id = jibh.location_id;
604:

Line 649: JAI_CMN_INVENTORY_ORGS org

645: jibh.last_updated_by,
646: jibh.last_update_date,
647: null -- last_update_login
648: from JAI_CMN_BOE_HDRS jibh,
649: JAI_CMN_INVENTORY_ORGS org
650: where jibh.boe_id = p_boe_id
651: and org.organization_id = jibh.organization_id
652: AND org.location_id = 0 ;
653:

Line 695: JAI_CMN_INVENTORY_ORGS org

691: jibh.last_update_date,
692: null -- last_update_login
693: from
694: JAI_CMN_BOE_HDRS jibh,
695: JAI_CMN_INVENTORY_ORGS org
696: where
697: jibh.boe_id = p_boe_id
698: and org.organization_id = jibh.organization_id
699: and org.location_id = jibh.location_id;