APPS.JAI_AP_UTILS_PKG dependencies on PO_VENDOR_SITES_ALL

Line 77: PO_VENDOR_SITES_ALL pvs

73: CURSOR for_accounting_date(id NUMBER) IS
74: SELECT jibh.tr6_date
75: FROM JAI_CMN_RG_PLA_HDRS jibh,
76: PO_VENDORS pv,
77: PO_VENDOR_SITES_ALL pvs
78: WHERE jibh.PLA_ID = id
79: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
80: AND pv.vendor_id = jibh.vendor_id;
81:

Line 220: PO_VENDOR_SITES_ALL pvs

216: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
217: jibh.LAST_UPDATE_DATE -- LAST_UPDATE_DATE
218: FROM JAI_CMN_RG_PLA_HDRS jibh,
219: PO_VENDORS pv,
220: PO_VENDOR_SITES_ALL pvs
221: WHERE jibh.PLA_ID = P_PLA_ID
222: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
223: AND pv.vendor_id = jibh.vendor_id
224: AND NVL(pvs.org_id, 0) = NVL(v_org_id, 0);

Line 512: po_vendor_sites_all pvs

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