[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 |