[Home] [Help]
699: -- Select the Funding Currency
700:
701: SELECT agreement_currency_code
702: INTO FundingCurrency
703: FROM pa_agreements_all agr,pa_draft_invoices_all di
704: WHERE agr.agreement_id = di.agreement_id
705: AND di.project_id = p_project_id
706: AND di.draft_invoice_num = p_draft_invoice_num;
707:
779: -- Select the Funding Currency
780:
781: SELECT agreement_currency_code
782: INTO FundingCurrency
783: FROM pa_agreements_all agr,pa_draft_invoices_all di
784: WHERE agr.agreement_id = di.agreement_id
785: AND di.project_id = p_project_id
786: AND di.draft_invoice_num = p_draft_invoice_num;
787: */
1592: hz_cust_site_uses hz_site,
1593: hz_cust_site_uses hz_site1
1594: WHERE EXISTS (SELECT NULL
1595: FROM pa_draft_invoices_all di,
1596: pa_agreements_all agr, pa_proj_retn_rules rt
1597: WHERE di.project_id = p_project_id
1598: AND di.request_id = p_request_id
1599: AND di.agreement_id = agr.agreement_id
1600: AND agr.customer_id = pc.customer_id
1630: di.draft_invoice_num,
1631: agr.agreement_id agreement_id,
1632: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1633: di.inv_currency_code invoice_currency_code
1634: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1635: pa_projects_all pr
1636: WHERE NVL(di.canceled_flag,'N') ='N'
1637: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1638: AND NVL(di.draft_invoice_num_credited,0) = 0
2959: agr.customer_id customer_id,
2960: rtn.task_id rtn_task_id,
2961: dii.line_num line_num_credited
2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2963: pa_agreements_all agr,
2964: pa_proj_retn_rules rtn
2965: WHERE dii.project_id = p_project_id
2966: AND dii.draft_invoice_num = l_org_invoice_num
2967: AND dii.project_id = di.project_id
3002: agr.customer_id customer_id,
3003: dii.retention_rule_id rtn_task_id, -- To get the retention lines
3004: dii.line_num line_num_credited
3005: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3006: pa_agreements_all agr
3007: WHERE dii.project_id = p_project_id
3008: AND dii.draft_invoice_num = l_org_invoice_num
3009: AND dii.project_id = di.project_id
3010: AND dii.draft_invoice_num = di.draft_invoice_num
3368: agr.customer_id customer_id,
3369: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3370: dii.inv_amount inv_amount
3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3372: pa_agreements_all agr,
3373: pa_proj_retn_rules rtn
3374: WHERE di.project_id = p_project_id
3375: AND di.draft_invoice_num = p_draft_invoice_num
3376: AND di.agreement_id = agr.agreement_id
3492: agr.customer_id customer_id,
3493: rtn.task_id rtn_task_id
3494: FROM pa_draft_invoice_items dii,
3495: pa_draft_invoices_all di,
3496: pa_agreements_all agr,
3497: pa_proj_retn_rules rtn
3498: WHERE di.project_id = p_project_id
3499: AND di.draft_invoice_num = p_draft_invoice_num
3500: AND di.agreement_id = agr.agreement_id
3575: agr.customer_id customer_id,
3576: NVL(rtn.task_id,dii.task_id) rtn_task_id
3577: FROM pa_draft_invoice_items dii,
3578: pa_draft_invoices_all di,
3579: pa_agreements_all agr,
3580: pa_proj_retn_rules rtn
3581: WHERE di.project_id = p_project_id
3582: AND di.draft_invoice_num = p_draft_invoice_num
3583: AND di.agreement_id = agr.agreement_id
3682: agr.customer_id customer_id,
3683: rtn.task_id rtn_task_id
3684: FROM pa_draft_invoice_items dii,
3685: pa_draft_invoices_all di,
3686: pa_agreements_all agr,
3687: pa_proj_retn_rules rtn
3688: WHERE di.project_id = p_project_id
3689: AND di.draft_invoice_num = p_draft_invoice_num
3690: AND di.agreement_id = agr.agreement_id
3732: agr.customer_id customer_id,
3733: dii.task_id dii_task_id
3734: FROM pa_draft_invoice_items dii,
3735: pa_draft_invoices_all di,
3736: pa_agreements_all agr
3737: WHERE di.project_id = p_project_id
3738: AND di.draft_invoice_num = p_draft_invoice_num
3739: AND di.agreement_id = agr.agreement_id
3740: AND di.project_id = dii.project_id