DBA Data[Home] [Help]

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 208: FROM po_reqexpress_headers_all prh,

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

Line 349: FROM po_reqexpress_headers_all prh,

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