APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on PO_REQEXPRESS_HEADERS_ALL

Line 108: FROM po_reqexpress_headers_all prh,

104: NVL(pl.closed_code, 'OPEN') line_closed_code,
105: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
106: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE+1)) expiration_date,
107: TRUNC(SYSDATE) system_date
108: FROM po_reqexpress_headers_all prh,
109: po_reqexpress_lines_all prl,
110: po_headers_all ph,
111: po_lines_all pl,
112: po_attribute_values_tlp po_tlp,

Line 209: FROM po_reqexpress_headers_all prh,

205: NVL(pl.closed_code, 'OPEN') line_closed_code,
206: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
207: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE+1)) expiration_date,
208: TRUNC(SYSDATE) system_date
209: FROM po_reqexpress_headers_all prh,
210: po_reqexpress_lines_all prl,
211: po_headers_all ph,
212: po_lines_all pl,
213: po_attribute_values_tlp po_tlp,

Line 351: FROM po_reqexpress_headers_all prh,

347: NVL(pl.closed_code, 'OPEN') line_closed_code,
348: NVL(TRUNC(ph.end_date), TRUNC(SYSDATE + 1)) end_date,
349: NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE+1)) expiration_date,
350: TRUNC(SYSDATE) system_date
351: FROM po_reqexpress_headers_all prh,
352: po_reqexpress_lines_all prl,
353: po_session_gt pogt,
354: po_headers_all ph,
355: po_lines_all pl,