View: CST_XLA_PO_DIST_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_PO_DIST_REF_V

View Text

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

Columns