[Home] [Help]
259: SUM(dii.project_bill_amount) pc_inv_amt
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'
288: SELECT 'T' into l_accepted_exist
289: FROM dual
290: WHERE EXISTS
291: (SELECT null
292: FROM pa_draft_invoices_all di
293: WHERE di.project_id = p_project_id
294: AND di.transfer_status_code = 'A'
295: AND di.system_reference IS NOT NULL) ;
296:
323: (SELECT di.project_id,
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'
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;
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
938: di.agreement_id,
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
987: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
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'
1069: , hz_cust_accounts cust_acct
1070: , pa_agreements_all agr
1071: , pa_project_customers pc
1072: , pa_summary_project_fundings spf
1073: , pa_draft_invoices_all di
1074: -- WHERE ra.customer_id = agr.customer_id
1075: WHERE cust_acct.cust_account_id= agr.customer_id
1076: AND cust_acct.party_id = party.party_id
1077: AND di.draft_invoice_num = NVL(p_draft_num,di.draft_invoice_num)
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
1169: di.agreement_id,
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
1230: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
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)