VIEW: APPS.GMF_XLA_COST_RVAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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