VIEW: APPS.CST_MGD_LIFO_PERIODS_V

Source

View Text - Preformatted

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')))

View Text - HTML Formatted

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')))