APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_DINVC

Line 2879: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVC

2875: end if;
2876:
2877: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2878:
2879: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVC
2880: ( WORKER_ID
2881: , ROW_ID
2882: , PROJECT_ORG_ID
2883: , PROJECT_ORGANIZATION_ID

Line 3184: from PJI_FM_EXTR_DINVC

3180: UPDATE pa_draft_invoices_all dinv
3181: SET dinv.pji_summarized_flag = 'O'
3182: -- later the flag is updated to null for those invoices that are closed
3183: WHERE dinv.rowid in (select row_id
3184: from PJI_FM_EXTR_DINVC
3185: where worker_id = p_worker_id
3186: and transfer_status_code = 'A'
3187: )
3188: AND ( (l_extraction_type = 'INCREMENTAL'

Line 3224: tabname => 'PJI_FM_EXTR_DINVC',

3220: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
3221: 'CURRENT_BATCH') = 1) then
3222: -- implicit commit
3223: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3224: tabname => 'PJI_FM_EXTR_DINVC',
3225: percent => 10,
3226: degree => PJI_UTILS.
3227: GET_DEGREE_OF_PARALLELISM);
3228: -- implicit commit

Line 3230: tabname => 'PJI_FM_EXTR_DINVC',

3226: degree => PJI_UTILS.
3227: GET_DEGREE_OF_PARALLELISM);
3228: -- implicit commit
3229: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3230: tabname => 'PJI_FM_EXTR_DINVC',
3231: colname => 'PROJECT_ID',
3232: percent => 10,
3233: degree => PJI_UTILS.
3234: GET_DEGREE_OF_PARALLELISM);

Line 3239: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVCITM

3235: end if;
3236:
3237: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3238:
3239: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVCITM
3240: ( WORKER_ID
3241: , PROJECT_ORG_ID
3242: , PROJECT_ORGANIZATION_ID
3243: , PROJECT_ID

Line 3292: PJI_FM_EXTR_DINVC part

3288: , to_number(null) ar_credit_memo_count
3289: , to_number(null) ar_unappr_invoice_count
3290: , to_number(null) ar_appr_invoice_count
3291: FROM
3292: PJI_FM_EXTR_DINVC part
3293: , pa_draft_invoice_items item
3294: WHERE
3295: l_extraction_type = 'FULL'
3296: and part.worker_id = p_worker_id

Line 3345: PJI_FM_EXTR_DINVC part

3341: , to_number(null) ar_credit_memo_count
3342: , to_number(null) ar_unappr_invoice_count
3343: , to_number(null) ar_appr_invoice_count
3344: FROM
3345: PJI_FM_EXTR_DINVC part
3346: , pa_draft_invoice_items item
3347: WHERE
3348: l_extraction_type = 'INCREMENTAL'
3349: and part.worker_id = p_worker_id

Line 3398: PJI_FM_EXTR_DINVC part

3394: , to_number(null) ar_credit_memo_count
3395: , to_number(null) ar_unappr_invoice_count
3396: , to_number(null) ar_appr_invoice_count
3397: FROM
3398: PJI_FM_EXTR_DINVC part
3399: , pa_draft_invoice_items item
3400: WHERE
3401: l_extraction_type = 'PARTIAL'
3402: and part.worker_id = p_worker_id

Line 3466: PJI_FM_EXTR_DINVC part

3462: 'A','A','S') || '_' ||
3463: part.approved_flag,
3464: 'S_Y',1,0) ar_appr_invoice_count
3465: FROM
3466: PJI_FM_EXTR_DINVC part
3467: WHERE
3468: part.worker_id = p_worker_id
3469: and part.gl_date is not null
3470: and part.pa_date is not null;

Line 3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);

3793: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3794:
3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

Line 3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);

3795: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3796:
3797: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3798:
3799: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3800:
3801: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3802:
3803: end CLEANUP;