Product: | BOM - Bills of Material |
---|---|
Description: | View to retrieve period information from pac period table restricted by mfg_lookups.lookup_type = CST_PAC_PERIOD_STATUS mfg_lookups.lookup_code = DECODE(pp.open_flag,'Y',2,'N',4,3) |
Implementation/DBA Data: | APPS.CST_MGD_LIFO_PERIODS_V |
SELECT DISTINCT PIC.PAC_PERIOD_ID
, PP.PERIOD_NAME
, PP.OPEN_FLAG PERIOD_OPEN_FLAG
, ML.MEANING PERIOD_STATUS
, PP.PERIOD_START_DATE
, PP.PERIOD_END_DATE
, PP.PERIOD_YEAR
, PP.PERIOD_NUM
, PP.COST_TYPE_ID
, CT.COST_TYPE COST_TYPE_NAME
, CT.DESCRIPTION COST_TYPE_DESCRIPTION
, XFI.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, XFI.NAME LEGAL_ENTITY_NAME
, PIC.COST_GROUP_ID
, CG.COST_GROUP COST_GROUP_NAME
, CG.DESCRIPTION COST_GROUP_DESCRIPTION
, CG.ORGANIZATION_ID MASTER_ORGANIZATION_ID
FROM CST_COST_GROUPS CG
, CST_PAC_ITEM_COSTS PIC
, CST_PAC_PERIODS PP
, CST_COST_TYPES CT
, XLE_FIRSTPARTY_INFORMATION_V XFI
, MFG_LOOKUPS ML
WHERE PIC.COST_GROUP_ID = CG.COST_GROUP_ID
AND PP.PAC_PERIOD_ID = PIC.PAC_PERIOD_ID
AND CT.COST_TYPE_ID = PP.COST_TYPE_ID
AND XFI.LEGAL_ENTITY_ID = PP.LEGAL_ENTITY
AND ML.LOOKUP_TYPE = 'CST_PAC_PERIOD_STATUS'
AND ((ML.LOOKUP_CODE = 2
AND PP.OPEN_FLAG = 'Y') OR (ML.LOOKUP_CODE = 4
AND PP.OPEN_FLAG = 'N') OR (ML.LOOKUP_CODE = 3
AND PP.OPEN_FLAG NOT IN ('Y'
, 'N')))