VIEW: APPS.CSTFV_PAC_QUANTITY_LAYERS

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTES */ cpql.QUANTITY_LAYER_ID /*PK*/ ,cpql.COST_LAYER_ID /*PK*/ ,cpql.PAC_PERIOD_ID ,cpql.COST_GROUP_ID ,cpql.INVENTORY_ITEM_ID ,ccg.organization_id ,cpql.LAYER_QUANTITY ,cpql.BEGIN_LAYER_QUANTITY /* FOREIGN KEYS RESOLVED */ ,cpp.period_name ,ccg.cost_group , '_KF:INV:MSTK:sy' /* ID */ /* WHO */ ,cpql.creation_date ,cpql.created_by ,cpql.last_update_date ,cpql.last_updated_by from mtl_system_items sy, CST_PAC_PERIODS cpp, CST_COST_GROUPS ccg, CST_PAC_QUANTITY_LAYERS cpql WHERE cpql.PAC_PERIOD_ID = cpp.PAC_PERIOD_ID and cpql.cost_group_id = ccg.cost_group_id and sy.organization_id = ccg.organization_id and ccg.cost_group_type = 2 and sy.inventory_item_id = cpql.inventory_item_id and '_SEC:ccg.organization_id' IS NOT NULL with read only

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTES */ CPQL.QUANTITY_LAYER_ID /*PK*/
, CPQL.COST_LAYER_ID /*PK*/
, CPQL.PAC_PERIOD_ID
, CPQL.COST_GROUP_ID
, CPQL.INVENTORY_ITEM_ID
, CCG.ORGANIZATION_ID
, CPQL.LAYER_QUANTITY
, CPQL.BEGIN_LAYER_QUANTITY /* FOREIGN KEYS RESOLVED */
, CPP.PERIOD_NAME
, CCG.COST_GROUP
, '_KF:INV:MSTK:SY' /* ID */ /* WHO */
, CPQL.CREATION_DATE
, CPQL.CREATED_BY
, CPQL.LAST_UPDATE_DATE
, CPQL.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, CST_PAC_PERIODS CPP
, CST_COST_GROUPS CCG
, CST_PAC_QUANTITY_LAYERS CPQL
WHERE CPQL.PAC_PERIOD_ID = CPP.PAC_PERIOD_ID
AND CPQL.COST_GROUP_ID = CCG.COST_GROUP_ID
AND SY.ORGANIZATION_ID = CCG.ORGANIZATION_ID
AND CCG.COST_GROUP_TYPE = 2
AND SY.INVENTORY_ITEM_ID = CPQL.INVENTORY_ITEM_ID
AND '_SEC:CCG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY