View: GMF_XLA_COST_RVAL_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Cost Revaluation
Implementation/DBA Data:	APPS.GMF_XLA_COST_RVAL_V

View Text

SELECT BAL.PERIOD_BALANCE_ID TRANSACTION_ID
, LED.LEDGER_ID
, EH.VALUATION_COST_TYPE_ID
, EH.EVENT_CLASS_CODE
, LED.NAME LEDGER_NAME
, EH.VALUATION_COST_TYPE
, TO_CHAR(BAL.PERIOD_BALANCE_ID) DOCUMENT_NUMBER
, TO_CHAR(BAL.ACCT_PERIOD_ID) ACCT_PERIOD_ID
, OACP.PERIOD_SET_NAME
, TO_CHAR(OACP.PERIOD_YEAR) PERIOD_YEAR
, TO_CHAR(OACP.PERIOD_NUM) PERIOD_NUM
, OACP.PERIOD_NAME
, OACP.DESCRIPTION PERIOD_DESCRIPTION
, OACP.PERIOD_START_DATE
, OACP.SCHEDULE_CLOSE_DATE
, OACP.PERIOD_CLOSE_DATE
, OACP.OPEN_FLAG
, OACP.SUMMARIZED_FLAG
, MP.ORGANIZATION_CODE
, BAL.SUBINVENTORY_CODE
, ITEM.ITEM_NUMBER ITEM_NAME
, BAL.LOT_NUMBER
, TO_CHAR(BAL.PRIMARY_QUANTITY) ||' '|| ITEM.PRIMARY_UOM_CODE PRIMARY_QUANTITY
, TO_CHAR(BAL.INTRANSIT_PRIMARY_QUANTITY) INTRANSIT_PRIMARY_QUANTITY
, ITEM.PRIMARY_UOM_CODE
, TO_CHAR(BAL.SECONDARY_QUANTITY) SECONDARY_QUANTITY
, TO_CHAR(BAL.INTRANSIT_SECONDARY_QUANTITY) INTRANSIT_SECONDARY_QUANTITY
, ITEM.SECONDARY_UOM_CODE
, EH.TRANSACTION_DATE
FROM GMF_PERIOD_BALANCES BAL
, GMF_XLA_EXTRACT_HEADERS EH
, MTL_ITEM_FLEXFIELDS ITEM
, MTL_PARAMETERS MP
, GL_LEDGERS LED
, ORG_ACCT_PERIODS OACP
WHERE EH.TRANSACTION_ID = BAL.PERIOD_BALANCE_ID
AND EH.ORGANIZATION_ID = BAL.ORGANIZATION_ID
AND EH.INVENTORY_ITEM_ID = BAL.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = BAL.ORGANIZATION_ID
AND ITEM.INVENTORY_ITEM_ID = BAL.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = BAL.ORGANIZATION_ID
AND LED.LEDGER_ID = EH.LEDGER_ID
AND OACP.ACCT_PERIOD_ID = BAL.ACCT_PERIOD_ID

Columns