APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 264: pa_draft_invoice_items dii

260: INTO
261: l_projfunc_inv_due_unaccepted,
262: l_proj_inv_due_unaccepted
263: FROM pa_draft_invoices_all di,
264: pa_draft_invoice_items dii
265: WHERE dii.project_id = di.project_id
266: AND dii.draft_invoice_num = di.draft_invoice_num
267: AND di.transfer_status_code <> 'A'
268: AND di.project_id = p_project_id

Line 328: pa_draft_invoice_items dii

324: di.system_reference system_reference,
325: SUM(dii.projfunc_bill_amount) pfc_inv_amt,
326: SUM(dii.project_bill_amount) pc_inv_amt
327: FROM pa_draft_invoices_all di,
328: pa_draft_invoice_items dii
329: WHERE di.project_id = dii.project_id
330: AND di.draft_invoice_num = dii.draft_invoice_num
331: AND di.transfer_status_code = 'A'
332: AND di.system_reference IS NOT NULL

Line 463: FROM pa_draft_invoice_items dii

459: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
460: INTO
461: l_pc_total_part_bill_amt,
462: l_pfc_total_part_bill_amt
463: FROM pa_draft_invoice_items dii
464: WHERE dii.project_id = p_project_id
465: AND EXISTS ( SELECT null
466: FROM pa_events eve
467: WHERE eve.event_num = dii.event_num

Line 476: FROM pa_draft_invoice_items dii, pa_events eve

472: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
473: INTO
474: l_pc_total_part_bill_amt,
475: l_pfc_total_part_bill_amt
476: FROM pa_draft_invoice_items dii, pa_events eve
477: WHERE eve.project_id = p_project_id
478: and eve.project_id = dii.project_id
479: and nvl(eve.task_id, 0) = nvl(dii.task_id,0)
480: and eve.event_num = nvl(dii.event_num,0)

Line 512: FROM pa_draft_invoice_items dii,pa_draft_invoices_all di

508: SUM(NVL(dii.projfunc_bill_amount,0)) unapproved_project_invoice
509: INTO
510: l_proj_unapprov_inv_amt,
511: l_projfunc_unapprov_inv_amt
512: FROM pa_draft_invoice_items dii,pa_draft_invoices_all di
513: WHERE dii.draft_invoice_num = di.draft_invoice_num
514: AND dii.project_id = di.project_id
515: AND di.project_id = p_project_id
516: AND di.approved_by_person_id IS NULL;

Line 887: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr

883: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
884: (SELECT
885: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
886: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
887: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
888: WHERE dii.draft_invoice_num = di.draft_invoice_num
889: AND dii.project_id = di.project_id
890: AND agr.customer_id = di.customer_id
891: AND agr.agreement_id = di.agreement_id

Line 943: pa_draft_invoice_items dii,

939: di.system_reference system_reference,
940: SUM(dii.project_bill_amount) pc_inv_amt,
941: SUM(dii.projfunc_bill_amount) pfc_inv_amt
942: FROM pa_draft_invoices_all di,
943: pa_draft_invoice_items dii,
944: PA_BILL_WRKBENCH_INV_TEMP pbwi
945: WHERE di.project_id = dii.project_id
946: AND di.draft_invoice_num = dii.draft_invoice_num
947: AND di.transfer_status_code = 'A'

Line 992: pa_draft_invoice_items dii

988: ( SELECT
989: SUM(dii.project_bill_amount) ,
990: SUM(dii.projfunc_bill_amount)
991: FROM pa_draft_invoices_all di,
992: pa_draft_invoice_items dii
993: WHERE di.project_id = dii.project_id
994: AND di.draft_invoice_num = dii.draft_invoice_num
995: AND di.transfer_status_code <> 'A'
996: AND di.customer_id = pbw.customer_id

Line 1107: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr

1103: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
1104: (SELECT
1105: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
1106: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt
1107: FROM pa_draft_invoices_all di , pa_draft_invoice_items dii , pa_agreements_all agr
1108: WHERE dii.draft_invoice_num = di.draft_invoice_num
1109: AND dii.project_id = di.project_id
1110: AND agr.customer_id = di.customer_id
1111: AND agr.agreement_id = di.agreement_id

Line 1174: pa_draft_invoice_items dii,

1170: di.system_reference system_reference,
1171: SUM(dii.project_bill_amount) pc_inv_amt,
1172: SUM(dii.projfunc_bill_amount) pfc_inv_amt
1173: FROM pa_draft_invoices_all di,
1174: pa_draft_invoice_items dii,
1175: PA_BILL_WRKBENCH_INV_TEMP pbwi
1176: WHERE di.project_id = dii.project_id
1177: AND di.draft_invoice_num = dii.draft_invoice_num
1178: AND di.agreement_id = NVL(p_agreement_id,di.agreement_id)

Line 1235: pa_draft_invoice_items dii

1231: ( SELECT
1232: SUM(dii.project_bill_amount) ,
1233: SUM(dii.projfunc_bill_amount)
1234: FROM pa_draft_invoices_all di,
1235: pa_draft_invoice_items dii
1236: WHERE di.project_id = dii.project_id
1237: AND di.draft_invoice_num = dii.draft_invoice_num
1238: AND di.agreement_id = NVL(p_agreement_id,di.agreement_id)
1239: AND di.draft_invoice_num = NVL(p_draft_num,di.draft_invoice_num)