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.

APPS.PJI_PJP_SUM_CUST dependencies on PJI_FP_CUST_PJP0

Line 14: -- 3. Only populate PJI_FP_CUST_PJP0.

10: -- Financial Planning Reporting Lines fact: PJI_FP_XBS_ACCUM_F.
11: --
12: -- 1. Only modify code in the indicated area.
13: -- 2. Do not issue any statements that result in a "commit" or a "rollback"
14: -- 3. Only populate PJI_FP_CUST_PJP0.
15: --
16: -- History
17: -- 19-MAR-2004 SVERMETT Created
18: --

Line 59: * Sample code with steps to customize custom measures for FP CUSTOM MEASURE TABLE(i.e.PJI_FP_CUST_PJP0) table*

55: **************************************************************/
56:
57: /**************************************************************************************************************
58: * *
59: * Sample code with steps to customize custom measures for FP CUSTOM MEASURE TABLE(i.e.PJI_FP_CUST_PJP0) table*
60: * *
61: * *
62: * FP BASIS TABLE ( I.E. PJI_FP_AGGR_PJP0) *
63: * -------------------------------------- *

Line 66: * keys, which are being used, in custom table (i.e. PJI_FP_CUST_PJP0) to store customized measures. *

62: * FP BASIS TABLE ( I.E. PJI_FP_AGGR_PJP0) *
63: * -------------------------------------- *
64: * This table is the first aggregation point after the transaction accum tables and provides a basis for *
65: * custom measures. This table has to be populated to store customized measures. It holds the mandatory *
66: * keys, which are being used, in custom table (i.e. PJI_FP_CUST_PJP0) to store customized measures. *
67: * To see the definition of this table and its columns, please refer ETRM. *
68: * *
69: * MANDOTORY PREREQUISTE TO DEFINE CUSTOM MEASURE *
70: * --------------------------------------------- *

Line 77: * FP CUSTOM MEASURES TABLE ( I.E. PJI_FP_CUST_PJP0) *

73: * -------------------------------------- *
74: * If the basis table is not populated then the program will not use and store the customized measures *
75: * at all. *
76: * *
77: * FP CUSTOM MEASURES TABLE ( I.E. PJI_FP_CUST_PJP0) *
78: * ------------------------------------------------- *
79: * This table is used to derive PJP custom measures only if derived measures are available in context *
80: * of RESOURCE and TASK. After customizing the custom measures, they are stored in this table. *
81: * Following is the list of custom measure available: *

Line 128: * INSERT INTO PJI_FP_CUST_PJP0 cust_i *

124: * ------------------------------------ *
125: * - Customizing a measure using EXPENDITURE_TYPE, and EXPENDITURE_ORG_ID *
126: * - Define computation logic for custom measure 1 *
127: * - Remove 1=2 from the SELECT part *
128: * INSERT INTO PJI_FP_CUST_PJP0 cust_i *
129: * ( *
130: * WORKER_ID, *
131: * TXN_ACCUM_HEADER_ID, *
132: * PROJECT_ID, *

Line 220: INSERT INTO PJI_FP_CUST_PJP0 cust_i

216: * 4. Custom 11 to 15 are exclusively for the Commitment related custom measures and thus these columns *
217: * would be processesed similar to that of Commitments *
218: **************************************************************************************************************/
219:
220: INSERT INTO PJI_FP_CUST_PJP0 cust_i
221: (
222: WORKER_ID,
223: TXN_ACCUM_HEADER_ID,
224: PROJECT_ID,