APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_RG_PLA_HDRS

Line 75: FROM JAI_CMN_RG_PLA_HDRS jibh,

71: WHERE invoice_id = inv_id;
72:
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

Line 218: FROM JAI_CMN_RG_PLA_HDRS jibh,

214: jibh.CREATED_BY, -- CREATED_BY,
215: jibh.CREATION_DATE, -- CREATION_DATE,
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

Line 228: FROM JAI_CMN_RG_PLA_HDRS jibh,

224: AND NVL(pvs.org_id, 0) = NVL(v_org_id, 0);
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;

Line 279: FROM JAI_CMN_RG_PLA_HDRS jibh,

275: jibh.CREATION_DATE, -- CREATION_DATE,
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 ;

Line 322: FROM JAI_CMN_RG_PLA_HDRS jibh,

318: jibh.CREATION_DATE, -- CREATION_DATE,
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;