DBA Data[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_DRAFT_INVOICE_ITEMS

Line 3293: , pa_draft_invoice_items item

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
3297: and part.project_id = item.project_id

Line 3346: , pa_draft_invoice_items item

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
3350: and part.project_id = item.project_id

Line 3399: , pa_draft_invoice_items item

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
3403: and part.project_id = item.project_id