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_AC_CUST_PJP0

Line 321: -- 3. Only populate PJI_AC_CUST_PJP0.

317: -- Activities Reporting Lines fact: PJI_AC_XBS_ACCUM_F.
318: --
319: -- 1. Only modify code in the indicated area.
320: -- 2. Do not issue any statements that result in a "commit" or a "rollback"
321: -- 3. Only populate PJI_AC_CUST_PJP0.
322: --
323: -- History
324: -- 19-MAR-2004 SVERMETT Created
325: --

Line 366: * Sample code with steps to customize custom measures for AC CUSTOM MEASURE TABLE(i.e.PJI_AC_CUST_PJP0) table*

362: **************************************************************/
363:
364:
365: /**************************************************************************************************************
366: * Sample code with steps to customize custom measures for AC CUSTOM MEASURE TABLE(i.e.PJI_AC_CUST_PJP0) table*
367: * *
368: * *
369: * AC BASIS TABLE ( I.E. PJI_AC_AGGR_PJP0) *
370: * -------------------------------------- *

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

369: * AC BASIS TABLE ( I.E. PJI_AC_AGGR_PJP0) *
370: * -------------------------------------- *
371: * This table is the first aggregation point after the transaction accum tables and provides a basis for *
372: * custom measures. This table has to be populated to store customized measures. It holds the mandatory *
373: * keys, which are being used, in custom table (i.e. PJI_AC_CUST_PJP0) to store customized measures. *
374: * To see the definition of this table and its columns, please refer ETRM. *
375: * *
376: * MANDOTORY PREREQUISTE TO DEFINE CUSTOM MEASURE *
377: * --------------------------------------------- *

Line 384: * AC CUSTOM MEASURES TABLE ( I.E. PJI_AC_CUST_PJP0) *

380: * -------------------------------------- *
381: * If the basis table is not populated then the program will not use and store the customized measures *
382: * at all.
383: * *
384: * AC CUSTOM MEASURES TABLE ( I.E. PJI_AC_CUST_PJP0) *
385: * ------------------------------------------------- *
386: * This table is used to derive PJP custom measures only if derived measures are available in context *
387: * of TASK. After customizing the custom measures, they are stored in this table. *
388: * Following is the list of custom measure available: *

Line 423: * INSERT INTO PJI_AC_CUST_PJP0 cust_i *

419: * ------------------------------------ *
420: * - Customizing a measure using CALENDAR_TYPE,CURRENCY_CODE,REVENUE *
421: * - Define computation logic for custom measure 1 *
422: * - Remove 1=2 from the SELECT part *
423: * INSERT INTO PJI_AC_CUST_PJP0 cust_i *
424: * ( *
425: * WORKER_ID, *
426: * PROJECT_ID, *
427: * PROJECT_ORG_ID, *

Line 501: INSERT INTO PJI_AC_CUST_PJP0 cust_i

497: * pl/sql logic has to ensure that it derives incremental amounts (ie., change since the last time *
498: * summarization has been run).
499: **************************************************************************************************************/
500:
501: INSERT INTO PJI_AC_CUST_PJP0 cust_i
502: (
503: WORKER_ID,
504: PROJECT_ID,
505: PROJECT_ORG_ID,