[Home] [Help]
View: CM_ACST_LED_V
Product: | GMF - Process Manufacturing Financials |
Description: | Acquisition cost LED view |
Implementation/DBA Data: |
APPS.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 |