VIEW: APPS.CSTFV_PRODUCT_LINE_ACCOUNT

Source

View Text - Preformatted

SELECT /* REGULAR ATTRIBUTE */ MCA.CATEGORY_ID , MCA.ORGANIZATION_ID , MCA.SUBINVENTORY_CODE , MCA.COST_GROUP_ID , '_KF:INV:MCAT:mc' , MP.ORGANIZATION_CODE , HAOU.NAME , MCA.SUBINVENTORY_CODE , CCG.COST_GROUP , /* ID */ MCS.CATEGORY_SET_NAME , MCA.CATEGORY_SET_ID , '_KF:SQLGL:GL#:gcc1' , MCA.MATERIAL_ACCOUNT , '_KF:SQLGL:GL#:gcc2' , MCA.MATERIAL_OVERHEAD_ACCOUNT , '_KF:SQLGL:GL#:gcc3' , MCA.RESOURCE_ACCOUNT , '_KF:SQLGL:GL#:gcc4' , MCA.OUTSIDE_PROCESSING_ACCOUNT , '_KF:SQLGL:GL#:gcc5' , MCA.OVERHEAD_ACCOUNT , '_KF:SQLGL:GL#:gcc6' , MCA.EXPENSE_ACCOUNT , '_KF:SQLGL:GL#:gcc7' , MCA.ENCUMBRANCE_ACCOUNT , '_KF:SQLGL:GL#:gcc8' , MCA.BRIDGING_ACCOUNT , MCA.ANALYTICAL_IPV , MCA.ANALYTICAL_PO_MIRROR , MCA.NON_INVOICED_SO , MCA.NON_INVOICED_REVENUE , MCA.ANALYTICAL_REVENUE_MIRROR , MCA.ANALYTICAL_MOGS , /* WHO */ MCA.CREATION_DATE , MCA.CREATED_BY , MCA.LAST_UPDATE_DATE , MCA.LAST_UPDATED_BY FROM GL_CODE_COMBINATIONS GCC1, GL_CODE_COMBINATIONS GCC2, GL_CODE_COMBINATIONS GCC3, GL_CODE_COMBINATIONS GCC4, GL_CODE_COMBINATIONS GCC5, GL_CODE_COMBINATIONS GCC6, GL_CODE_COMBINATIONS GCC7, GL_CODE_COMBINATIONS GCC8, MTL_CATEGORIES MC, MTL_CATEGORY_SETS MCS, CST_COST_GROUPS CCG, HR_ALL_ORGANIZATION_UNITS HAOU, MTL_PARAMETERS MP, MTL_CATEGORY_ACCOUNTS MCA WHERE MCA.CATEGORY_ID = MC.CATEGORY_ID AND HAOU.ORGANIZATION_ID = MCA.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MCA.ORGANIZATION_ID AND CCG.ORGANIZATION_ID = MCA.ORGANIZATION_ID AND MCA.MATERIAL_ACCOUNT = GCC1.CODE_COMBINATION_ID (+) AND MCA.MATERIAL_OVERHEAD_ACCOUNT = GCC2.CODE_COMBINATION_ID (+) AND MCA.RESOURCE_ACCOUNT = GCC3.CODE_COMBINATION_ID (+) AND MCA.OUTSIDE_PROCESSING_ACCOUNT = GCC4.CODE_COMBINATION_ID (+) AND MCA.OVERHEAD_ACCOUNT = GCC5.CODE_COMBINATION_ID (+) AND MCA.EXPENSE_ACCOUNT= GCC6.CODE_COMBINATION_ID (+) AND MCA.ENCUMBRANCE_ACCOUNT = GCC7.CODE_COMBINATION_ID (+) AND MCA.BRIDGING_ACCOUNT = GCC8.CODE_COMBINATION_ID (+) AND MCA.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID (+) AND '_SEC:mca.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* REGULAR ATTRIBUTE */ MCA.CATEGORY_ID
, MCA.ORGANIZATION_ID
, MCA.SUBINVENTORY_CODE
, MCA.COST_GROUP_ID
, '_KF:INV:MCAT:MC'
, MP.ORGANIZATION_CODE
, HAOU.NAME
, MCA.SUBINVENTORY_CODE
, CCG.COST_GROUP
, /* ID */ MCS.CATEGORY_SET_NAME
, MCA.CATEGORY_SET_ID
, '_KF:SQLGL:GL#:GCC1'
, MCA.MATERIAL_ACCOUNT
, '_KF:SQLGL:GL#:GCC2'
, MCA.MATERIAL_OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC3'
, MCA.RESOURCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC4'
, MCA.OUTSIDE_PROCESSING_ACCOUNT
, '_KF:SQLGL:GL#:GCC5'
, MCA.OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC6'
, MCA.EXPENSE_ACCOUNT
, '_KF:SQLGL:GL#:GCC7'
, MCA.ENCUMBRANCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC8'
, MCA.BRIDGING_ACCOUNT
, MCA.ANALYTICAL_IPV
, MCA.ANALYTICAL_PO_MIRROR
, MCA.NON_INVOICED_SO
, MCA.NON_INVOICED_REVENUE
, MCA.ANALYTICAL_REVENUE_MIRROR
, MCA.ANALYTICAL_MOGS
, /* WHO */ MCA.CREATION_DATE
, MCA.CREATED_BY
, MCA.LAST_UPDATE_DATE
, MCA.LAST_UPDATED_BY
FROM GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, GL_CODE_COMBINATIONS GCC3
, GL_CODE_COMBINATIONS GCC4
, GL_CODE_COMBINATIONS GCC5
, GL_CODE_COMBINATIONS GCC6
, GL_CODE_COMBINATIONS GCC7
, GL_CODE_COMBINATIONS GCC8
, MTL_CATEGORIES MC
, MTL_CATEGORY_SETS MCS
, CST_COST_GROUPS CCG
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, MTL_CATEGORY_ACCOUNTS MCA
WHERE MCA.CATEGORY_ID = MC.CATEGORY_ID
AND HAOU.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND CCG.ORGANIZATION_ID = MCA.ORGANIZATION_ID
AND MCA.MATERIAL_ACCOUNT = GCC1.CODE_COMBINATION_ID (+)
AND MCA.MATERIAL_OVERHEAD_ACCOUNT = GCC2.CODE_COMBINATION_ID (+)
AND MCA.RESOURCE_ACCOUNT = GCC3.CODE_COMBINATION_ID (+)
AND MCA.OUTSIDE_PROCESSING_ACCOUNT = GCC4.CODE_COMBINATION_ID (+)
AND MCA.OVERHEAD_ACCOUNT = GCC5.CODE_COMBINATION_ID (+)
AND MCA.EXPENSE_ACCOUNT= GCC6.CODE_COMBINATION_ID (+)
AND MCA.ENCUMBRANCE_ACCOUNT = GCC7.CODE_COMBINATION_ID (+)
AND MCA.BRIDGING_ACCOUNT = GCC8.CODE_COMBINATION_ID (+)
AND MCA.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID (+)
AND '_SEC:MCA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY