APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_DREVN

Line 400: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DREVN

396: l_transition_flag :=
397: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,
398: 'TRANSITION');
399:
400: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DREVN
401: (
402: ROW_ID
403: , WORKER_ID
404: , LINE_SOURCE_TYPE

Line 673: PJI_FM_EXTR_DREVN

669: BATCH_ID,
670: null,
671: null
672: from
673: PJI_FM_EXTR_DREVN
674: where
675: (LINE_SOURCE_TYPE = 'R' and
676: PJI_SUMMARIZED_FLAG is not null) or
677: (LINE_SOURCE_TYPE = 'L');

Line 750: from PJI_FM_EXTR_DREVN drvn

746: UPDATE pa_draft_revenues_all drv
747: SET drv.pji_summarized_flag = null
748: WHERE drv.rowid in (select /*+ cardinality(drvn, 1) */
749: drvn.row_id
750: from PJI_FM_EXTR_DREVN drvn
751: where drvn.pji_summarized_flag is not null
752: and drvn.LINE_SOURCE_TYPE = 'R'
753: and drvn.batch_id = l_helper_batch_id);
754:

Line 759: from PJI_FM_EXTR_DREVN

755: -- Clean up log table
756:
757: DELETE pa_pji_proj_events_log
758: WHERE rowid in (select row_id
759: from PJI_FM_EXTR_DREVN
760: where line_source_type = 'L'
761: and batch_id = l_helper_batch_id);
762:
763: update PJI_HELPER_BATCH_MAP

Line 898: tabname => 'PJI_FM_EXTR_DREVN',

894: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
895: 'CURRENT_BATCH') = 1) then
896: -- implicit commit
897: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
898: tabname => 'PJI_FM_EXTR_DREVN',
899: percent => 10,
900: degree => PJI_UTILS.
901: GET_DEGREE_OF_PARALLELISM);
902: -- implicit commit

Line 904: tabname => 'PJI_FM_EXTR_DREVN',

900: degree => PJI_UTILS.
901: GET_DEGREE_OF_PARALLELISM);
902: -- implicit commit
903: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
904: tabname => 'PJI_FM_EXTR_DREVN',
905: colname => 'PROJECT_ID',
906: percent => 10,
907: degree => PJI_UTILS.
908: GET_DEGREE_OF_PARALLELISM);

Line 1264: From PJI_FM_EXTR_DREVN drev

1260: , to_number(null) AS EOU_UBR
1261: , to_number(null) AS EOU_UER
1262: , to_number(null) AS QUANTITY
1263: , to_number(null) AS BILL_QUANTITY
1264: From PJI_FM_EXTR_DREVN drev
1265: , pa_agreements_all ag
1266: , pa_project_customers cust
1267: , pa_cust_rev_dist_lines_all crdl
1268: Where 1 = 1

Line 1501: , PJI_FM_EXTR_DREVN drev

1497: From pa_agreements_all ag
1498: , pa_project_customers cust
1499: , pa_events ev
1500: , pa_event_types evt
1501: , PJI_FM_EXTR_DREVN drev
1502: , pa_cust_event_rdl_all erdl
1503: Where 1 = 1
1504: And drev.worker_id = p_worker_id
1505: And drev.project_id = erdl.project_id

Line 1693: tabname => 'PJI_FM_EXTR_DREVN',

1689: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
1690: 'CURRENT_BATCH') = 1) then
1691: -- implicit commit
1692: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
1693: tabname => 'PJI_FM_EXTR_DREVN',
1694: percent => 10,
1695: degree => PJI_UTILS.
1696: GET_DEGREE_OF_PARALLELISM);
1697: end if;

Line 1733: PJI_FM_EXTR_DREVN drev

1729: , drev.line_source_type
1730: , cust.bill_another_project_flag
1731: , cust.customer_id
1732: FROM
1733: PJI_FM_EXTR_DREVN drev
1734: , pa_agreements_all ag
1735: , pa_project_customers cust
1736: , pa_cust_rev_dist_lines_all crdl
1737: WHERE

Line 1827: PJI_FM_EXTR_DREVN drev

1823: , drev.pa_period_name pa_period_name
1824: , drev.gl_date gl_date
1825: , drev.gl_period_name gl_period_name
1826: FROM
1827: PJI_FM_EXTR_DREVN drev
1828: , pa_agreements_all ag
1829: , pa_project_customers cust
1830: , pa_events ev
1831: , pa_event_types evt

Line 3776: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);

3772: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3773:
3774: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG', 'NORMAL',null);
3775:
3776: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN', 'NORMAL',null);
3777:
3778: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CDL', 'NORMAL',null);
3779:
3780: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);