VIEW: APPS.CST_XLA_PO_DIST_REF_V

Source

View Text - Preformatted

SELECT /*+ Leading(pod,xdl) index(xdl XLA_DISTRIBUTION_LINKS_N1) */ xdl.source_distribution_id_num_1 xl_distribution_id , MAX(xl.code_combination_id) xl_ccid , SUBSTRB(MAX(xl.description),1,240) xl_description , MAX(xh.period_name) xl_period_name , MAX(xh.accounting_date) xl_accounting_date FROM xla_distribution_links xdl , xla_ae_lines xl , xla_ae_headers xh , po_distributions_all pod , financials_system_params_all fsp WHERE xdl.application_id = 201 AND xdl.source_distribution_type = 'PO_DISTRIBUTIONS_ALL' AND xdl.source_distribution_id_num_1 = pod.po_distribution_id AND pod.org_id = fsp.org_id AND xl.application_id = 201 AND xl.ae_header_id = xdl.ae_header_id AND xl.ae_line_num = xdl.ae_line_num AND xl.ledger_id = fsp.set_of_books_id AND xh.application_id = 201 AND fsp.set_of_books_id = xh.ledger_id AND xl.ae_header_id = xh.ae_header_id AND xh.ae_header_id = xdl.ae_header_id GROUP BY xdl.source_distribution_id_num_1

View Text - HTML Formatted

SELECT /*+ LEADING(POD
, XDL) INDEX(XDL XLA_DISTRIBUTION_LINKS_N1) */ XDL.SOURCE_DISTRIBUTION_ID_NUM_1 XL_DISTRIBUTION_ID
, MAX(XL.CODE_COMBINATION_ID) XL_CCID
, SUBSTRB(MAX(XL.DESCRIPTION)
, 1
, 240) XL_DESCRIPTION
, MAX(XH.PERIOD_NAME) XL_PERIOD_NAME
, MAX(XH.ACCOUNTING_DATE) XL_ACCOUNTING_DATE
FROM XLA_DISTRIBUTION_LINKS XDL
, XLA_AE_LINES XL
, XLA_AE_HEADERS XH
, PO_DISTRIBUTIONS_ALL POD
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE XDL.APPLICATION_ID = 201
AND XDL.SOURCE_DISTRIBUTION_TYPE = 'PO_DISTRIBUTIONS_ALL'
AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1 = POD.PO_DISTRIBUTION_ID
AND POD.ORG_ID = FSP.ORG_ID
AND XL.APPLICATION_ID = 201
AND XL.AE_HEADER_ID = XDL.AE_HEADER_ID
AND XL.AE_LINE_NUM = XDL.AE_LINE_NUM
AND XL.LEDGER_ID = FSP.SET_OF_BOOKS_ID
AND XH.APPLICATION_ID = 201
AND FSP.SET_OF_BOOKS_ID = XH.LEDGER_ID
AND XL.AE_HEADER_ID = XH.AE_HEADER_ID
AND XH.AE_HEADER_ID = XDL.AE_HEADER_ID GROUP BY XDL.SOURCE_DISTRIBUTION_ID_NUM_1