VIEW: APPS.FII_GL_LOCAL_SNAP_F_P_V

Source

View Text - Preformatted

SELECT YEAR_ID YEAR_ID, COST_CENTER_ID COST_CENTER_ID, COMPANY_ID COMPANY_ID, FIN_CATEGORY_ID FIN_CATEGORY_ID, USER_DIM1_ID FUD1_ID, USER_DIM2_ID FUD2_ID, LEDGER_ID LEDGER_ID, FIN_CAT_TYPE_CODE FIN_CAT_TYPE_CODE, PRIM_G_MONTH1 G_MONTH1, PRIM_G_MONTH2 G_MONTH2, PRIM_G_MONTH3 G_MONTH3, PRIM_G_MONTH4 G_MONTH4, PRIM_G_MONTH5 G_MONTH5, PRIM_G_MONTH6 G_MONTH6, PRIM_G_MONTH7 G_MONTH7, PRIM_G_MONTH8 G_MONTH8, PRIM_G_MONTH9 G_MONTH9, PRIM_G_MONTH10 G_MONTH10, PRIM_G_MONTH11 G_MONTH11, PRIM_G_MONTH12 G_MONTH12, PRIM_G_MONTH13 G_MONTH13, PRIM_G_QTR1 G_QTR1, PRIM_G_QTR2 G_QTR2, PRIM_G_QTR3 G_QTR3, PRIM_G_QTR4 G_QTR4, PRIM_G_YEAR G_YEAR, PRIM_G_MTD G_MTD, PRIM_G_QTD G_QTD, PRIM_G_YTD G_YTD, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE from fii_gl_local_snap_f

View Text - HTML Formatted

SELECT YEAR_ID YEAR_ID
, COST_CENTER_ID COST_CENTER_ID
, COMPANY_ID COMPANY_ID
, FIN_CATEGORY_ID FIN_CATEGORY_ID
, USER_DIM1_ID FUD1_ID
, USER_DIM2_ID FUD2_ID
, LEDGER_ID LEDGER_ID
, FIN_CAT_TYPE_CODE FIN_CAT_TYPE_CODE
, PRIM_G_MONTH1 G_MONTH1
, PRIM_G_MONTH2 G_MONTH2
, PRIM_G_MONTH3 G_MONTH3
, PRIM_G_MONTH4 G_MONTH4
, PRIM_G_MONTH5 G_MONTH5
, PRIM_G_MONTH6 G_MONTH6
, PRIM_G_MONTH7 G_MONTH7
, PRIM_G_MONTH8 G_MONTH8
, PRIM_G_MONTH9 G_MONTH9
, PRIM_G_MONTH10 G_MONTH10
, PRIM_G_MONTH11 G_MONTH11
, PRIM_G_MONTH12 G_MONTH12
, PRIM_G_MONTH13 G_MONTH13
, PRIM_G_QTR1 G_QTR1
, PRIM_G_QTR2 G_QTR2
, PRIM_G_QTR3 G_QTR3
, PRIM_G_QTR4 G_QTR4
, PRIM_G_YEAR G_YEAR
, PRIM_G_MTD G_MTD
, PRIM_G_QTD G_QTD
, PRIM_G_YTD G_YTD
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AMOUNT_TYPE_CODE AMOUNT_TYPE_CODE
FROM FII_GL_LOCAL_SNAP_F