DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 109: po_reqexpress_lines_all prl,

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,
113: po_line_types_b pltb,

Line 210: po_reqexpress_lines_all prl,

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,
214: po_line_types_b pltb,

Line 352: po_reqexpress_lines_all prl,

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,
356: po_attribute_values_tlp po_tlp,