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 209: po_reqexpress_lines_all prl,

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

Line 350: po_reqexpress_lines_all prl,

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