eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CSTFV_PRODUCT_LINE_ACCOUNT

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_PRODUCT_LINE_ACCOUNT

View Text

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

Columns

Name
CATEGORY_ID
ORGANIZATION_ID
SUBINVENTORY_CODE
COST_GROUP_ID
"_KF:CATEGORY_NAME:_CO"
ORGANIZATION_CODE
ORGANIZATION_NAME
SUBINVENTORY_NAME
COST_GROUP_NAME
CATEGORY_SET_NAME
CATEGORY_SET_ID
"_KF:ACC_NO:MATL:_CO"
MATERIAL_ACCOUNT
"_KF:ACC_NO:MTL_OVERHEAD:_CO"
MATERIAL_OVERHEAD_ACCOUNT
"_KF:ACC_NO:RESOURCE:_CO"
RESOURCE_ACCOUNT
"_KF:ACC_NO:OUTSIDE_PROCS:_CO"
OUTSIDE_PROCESSING_ACCOUNT
"_KF:ACC_NO:OVERHEAD:_CO"
OVERHEAD_ACCOUNT
"_KF:ACC_NO:EXPENSE:_CO"
EXPENSE_ACCOUNT
"_KF:ACC_NO:ENCUMBRANCE:_CO"
ENCUMBRANCE_ACCOUNT
"_KF:ACC_NO:BRIDGING:_CO"
BRIDGING_ACCOUNT
ANALYTICAL_IPV
ANALYTICAL_PO_MIRROR
NON_INVOICED_SO
NON_INVOICED_REVENUE
ANALYTICAL_REVENUE_MIRROR
ANALYTICAL_MOGS
CREATED_DATE
CREATED_BY
UPDATED_DATE
UPDATED_BY