FND Design Data [Home] [Help]

View: PO_ENC_AEL_GL_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.PO_ENC_AEL_GL_V
View Text

SELECT 201
, POD.SET_OF_BOOKS_ID
, POH.ORG_ID
, OOD.ORGANIZATION_CODE
, PLL.SHIP_TO_ORGANIZATION_ID
, 'PURCHASES'
, 'PO'
, PL1.DISPLAYED_FIELD
, PL1.LOOKUP_CODE
, POH.SEGMENT1
, POH.PO_HEADER_ID
, POH.CREATION_DATE
, POH.COMMENTS
, 'PO'
, POH.PO_HEADER_ID
, JEL.CODE_COMBINATION_ID
, POH.CURRENCY_CODE
, JEL.ENTERED_DR
, JEL.ENTERED_CR
, JEL.ACCOUNTED_DR
, JEL.ACCOUNTED_CR
, JEH.JE_HEADER_ID
, JEL.JE_LINE_NUM
, JEH.CURRENCY_CONVERSION_DATE
, JEH.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, JEH.CURRENCY_CONVERSION_RATE
, JEL.EFFECTIVE_DATE
, PL1.DISPLAYED_FIELD
, RPAD(PL1.DISPLAYED_FIELD
, 80)
, POH.CREATION_DATE
, POH.CREATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_LOGIN
, POH.REQUEST_ID
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.SEGMENT1
, PL1.DISPLAYED_FIELD
, PR.RELEASE_NUM
, POL.LINE_NUM
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.QUANTITY
, POL.UNIT_PRICE
, POD.DESTINATION_SUBINVENTORY
FROM PO_LOOKUP_CODES PL1
, PO_HEADERS POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_DISTRIBUTIONS_ALL POD
, PO_RELEASES_ALL PR
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_JE_HEADERS JEH
, GL_JE_LINES JEL
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE PL1.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'PO TYPE'
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID
AND OOD.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID
AND OOD.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID
AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND GLCT.CONVERSION_TYPE(+) = JEH.CURRENCY_CONVERSION_TYPE
AND JEL.REFERENCE_2 = PLL.PO_HEADER_ID
AND JEL.REFERENCE_3 = POD.PO_DISTRIBUTION_ID
AND JEL.REFERENCE_4 = POH.SEGMENT1

Columns

Name
APPLICATION_ID
SET_OF_BOOKS_ID
ORG_ID
INVENTORY_ORGANIZATION_CODE
INVENTORY_ORGANIZATION_ID
TRX_CLASS_NAME
TRX_CLASS
TRX_TYPE_NAME
TRX_TYPE_C
TRX_NUMBER_DISPLAYED
TRX_NUMBER_N
TRX_DATE
COMMENTS
TRX_HDR_TABLE
TRX_HDR_ID
CODE_COMBINATION_ID
CURRENCY_CODE
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
JE_HEADER_ID
JE_LINE_NUM
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_TYPE
CURRENCY_USER_CONVERSION_TYPE
CURRENCY_CONVERSION_RATE
ACCOUNTING_DATE
AE_LINE_REFERENCE
AE_LINE_REFERENCE_INTERNAL
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
PO_ORDER_NUMBER
PO_ORDER_TYPE
PO_ORDER_RELEASE_NUM
PO_LINE_NUM
INVENTORY_ITEM_ID
INVENTORY_ITEM_REVISION
ITEM_DESCRIPTION
TRX_UOM
TRX_QUANTITY
UNIT_PRICE
SUBINVENTORY