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.

[Home] [Help]

APPS.PJI_FM_EXTR dependencies on PA_DRAFT_INVOICE_ITEMS

Line 3280: , pa_draft_invoice_items item

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

Line 3333: , pa_draft_invoice_items item

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

Line 3386: , pa_draft_invoice_items item

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