APPS.JAI_AP_UTILS_PKG dependencies on PO_VENDOR_SITES_ALL

Line 89: PO_VENDOR_SITES_ALL pvs

85: CURSOR for_accounting_date(id NUMBER) IS
86: SELECT jibh.tr6_date
87: FROM JAI_CMN_RG_PLA_HDRS jibh,
88: PO_VENDORS pv,
89: PO_VENDOR_SITES_ALL pvs
90: WHERE jibh.PLA_ID = id
91: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
92: AND pv.vendor_id = jibh.vendor_id;
93:

Line 232: PO_VENDOR_SITES_ALL pvs

228: jibh.LAST_UPDATED_BY, -- LAST_UPDATED_BY,
229: jibh.LAST_UPDATE_DATE -- LAST_UPDATE_DATE
230: FROM JAI_CMN_RG_PLA_HDRS jibh,
231: PO_VENDORS pv,
232: PO_VENDOR_SITES_ALL pvs
233: WHERE jibh.PLA_ID = P_PLA_ID
234: AND pvs.vendor_site_id (+)= jibh.vendor_site_id
235: AND pv.vendor_id = jibh.vendor_id
236: AND NVL(pvs.org_id, 0) = NVL(v_org_id, 0);

Line 582: po_vendor_sites_all pvs

578: -- Added by Wenqiong Zhou for Bug #1168411 BOE enhancement End
579: FROM
580: JAI_CMN_BOE_HDRS jibh,
581: po_vendors pv,
582: po_vendor_sites_all pvs
583: where jibh.boe_id = p_boe_id
584: and pvs.vendor_site_id (+)= jibh.vendor_site_id
585: and pv.vendor_id = jibh.vendor_id
586: and nvl(pvs.org_id, 0) = nvl(v_org_id, 0);