APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_BOE_HDRS

Line 510: JAI_CMN_BOE_HDRS jibh,

506: trunc(jibh.creation_date),
507: jibh.last_updated_by,
508: trunc(jibh.last_update_date)
509: FROM
510: JAI_CMN_BOE_HDRS jibh,
511: po_vendors pv,
512: po_vendor_sites_all pvs
513: where jibh.boe_id = p_boe_id
514: and pvs.vendor_site_id (+)= jibh.vendor_site_id

Line 520: from JAI_CMN_BOE_HDRS jibh,

516: and nvl(pvs.org_id, 0) = nvl(v_org_id, 0);
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;

Line 568: from JAI_CMN_BOE_HDRS jibh,

564: trunc(jibh.creation_date),
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 ;

Line 613: JAI_CMN_BOE_HDRS jibh,

609: jibh.last_updated_by,
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