FND Design Data [Home] [Help]

View: CM_ACST_LED_V

Product: GMF - Process Manufacturing Financials
Description: Acquisition cost LED view
Implementation/DBA Data: ViewAPPS.CM_ACST_LED_V
View Text

SELECT DISTINCT LED.ORGANIZATION_ID
, MST.CALENDAR_CODE
, MST.PERIOD_ID
, MST.PERIOD_CODE
, MTHD.COST_MTHD_CODE
, MTHD.COST_TYPE_ID
, LED.INVENTORY_ITEM_ID
FROM CM_ACST_LED LED
, CM_MTHD_MST MTHD
, GMF_PERIOD_STATUSES MST
WHERE LED.COST_TYPE_ID = MTHD.COST_TYPE_ID
AND MST.PERIOD_ID = LED.PERIOD_ID

Columns

Name
ORGANIZATION_ID
CALENDAR_CODE
PERIOD_ID
PERIOD_CODE
COST_MTHD_CODE
COST_TYPE_ID
INVENTORY_ITEM_ID