APPS.PJI_FM_EXTR dependencies on PJI_FM_EXTR_DINVC

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

2862: end if;
2863:
2864: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2865:
2866: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVC
2867: ( WORKER_ID
2868: , ROW_ID
2869: , PROJECT_ORG_ID
2870: , PROJECT_ORGANIZATION_ID

Line 3171: from PJI_FM_EXTR_DINVC

3167: UPDATE pa_draft_invoices_all dinv
3168: SET dinv.pji_summarized_flag = 'O'
3169: -- later the flag is updated to null for those invoices that are closed
3170: WHERE dinv.rowid in (select row_id
3171: from PJI_FM_EXTR_DINVC
3172: where worker_id = p_worker_id
3173: and transfer_status_code = 'A'
3174: )
3175: AND ( (l_extraction_type = 'INCREMENTAL'

Line 3211: tabname => 'PJI_FM_EXTR_DINVC',

3207: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
3208: 'CURRENT_BATCH') = 1) then
3209: -- implicit commit
3210: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3211: tabname => 'PJI_FM_EXTR_DINVC',
3212: percent => 10,
3213: degree => PJI_UTILS.
3214: GET_DEGREE_OF_PARALLELISM);
3215: -- implicit commit

Line 3217: tabname => 'PJI_FM_EXTR_DINVC',

3213: degree => PJI_UTILS.
3214: GET_DEGREE_OF_PARALLELISM);
3215: -- implicit commit
3216: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3217: tabname => 'PJI_FM_EXTR_DINVC',
3218: colname => 'PROJECT_ID',
3219: percent => 10,
3220: degree => PJI_UTILS.
3221: GET_DEGREE_OF_PARALLELISM);

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

3222: end if;
3223:
3224: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3225:
3226: INSERT /*+ APPEND */ INTO PJI_FM_EXTR_DINVCITM
3227: ( WORKER_ID
3228: , PROJECT_ORG_ID
3229: , PROJECT_ORGANIZATION_ID
3230: , PROJECT_ID

Line 3279: PJI_FM_EXTR_DINVC part

3275: , to_number(null) ar_credit_memo_count
3276: , to_number(null) ar_unappr_invoice_count
3277: , to_number(null) ar_appr_invoice_count
3278: FROM
3279: PJI_FM_EXTR_DINVC part
3280: , pa_draft_invoice_items item
3281: WHERE
3282: l_extraction_type = 'FULL'
3283: and part.worker_id = p_worker_id

Line 3332: PJI_FM_EXTR_DINVC part

3328: , to_number(null) ar_credit_memo_count
3329: , to_number(null) ar_unappr_invoice_count
3330: , to_number(null) ar_appr_invoice_count
3331: FROM
3332: PJI_FM_EXTR_DINVC part
3333: , pa_draft_invoice_items item
3334: WHERE
3335: l_extraction_type = 'INCREMENTAL'
3336: and part.worker_id = p_worker_id

Line 3385: PJI_FM_EXTR_DINVC part

3381: , to_number(null) ar_credit_memo_count
3382: , to_number(null) ar_unappr_invoice_count
3383: , to_number(null) ar_appr_invoice_count
3384: FROM
3385: PJI_FM_EXTR_DINVC part
3386: , pa_draft_invoice_items item
3387: WHERE
3388: l_extraction_type = 'PARTIAL'
3389: and part.worker_id = p_worker_id

Line 3453: PJI_FM_EXTR_DINVC part

3449: 'A','A','S') || '_' ||
3450: part.approved_flag,
3451: 'S_Y',1,0) ar_appr_invoice_count
3452: FROM
3453: PJI_FM_EXTR_DINVC part
3454: WHERE
3455: part.worker_id = p_worker_id
3456: and part.gl_date is not null
3457: and part.pa_date is not null;

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

3780: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_CRDL', 'NORMAL',null);
3781:
3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);

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

3782: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_REXT_ERDL', 'NORMAL',null);
3783:
3784: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC', 'NORMAL',null);
3785:
3786: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM', 'NORMAL',null);
3787:
3788: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_ARINV', 'NORMAL',null);
3789:
3790: end CLEANUP;