[Home] [Help]
681: -- Select the Funding Currency
682:
683: SELECT agreement_currency_code
684: INTO FundingCurrency
685: FROM pa_agreements_all agr,pa_draft_invoices_all di
686: WHERE agr.agreement_id = di.agreement_id
687: AND di.project_id = p_project_id
688: AND di.draft_invoice_num = p_draft_invoice_num;
689:
761: -- Select the Funding Currency
762:
763: SELECT agreement_currency_code
764: INTO FundingCurrency
765: FROM pa_agreements_all agr,pa_draft_invoices_all di
766: WHERE agr.agreement_id = di.agreement_id
767: AND di.project_id = p_project_id
768: AND di.draft_invoice_num = p_draft_invoice_num;
769: */
1574: hz_cust_site_uses hz_site,
1575: hz_cust_site_uses hz_site1
1576: WHERE EXISTS (SELECT NULL
1577: FROM pa_draft_invoices_all di,
1578: pa_agreements_all agr, pa_proj_retn_rules rt
1579: WHERE di.project_id = p_project_id
1580: AND di.request_id = p_request_id
1581: AND di.agreement_id = agr.agreement_id
1582: AND agr.customer_id = pc.customer_id
1612: di.draft_invoice_num,
1613: agr.agreement_id agreement_id,
1614: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1615: di.inv_currency_code invoice_currency_code
1616: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1617: pa_projects_all pr
1618: WHERE NVL(di.canceled_flag,'N') ='N'
1619: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1620: AND NVL(di.draft_invoice_num_credited,0) = 0
2922: agr.customer_id customer_id,
2923: rtn.task_id rtn_task_id,
2924: dii.line_num line_num_credited
2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2926: pa_agreements_all agr,
2927: pa_proj_retn_rules rtn
2928: WHERE dii.project_id = p_project_id
2929: AND dii.draft_invoice_num = l_org_invoice_num
2930: AND dii.project_id = di.project_id
2965: agr.customer_id customer_id,
2966: dii.retention_rule_id rtn_task_id, -- To get the retention lines
2967: dii.line_num line_num_credited
2968: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2969: pa_agreements_all agr
2970: WHERE dii.project_id = p_project_id
2971: AND dii.draft_invoice_num = l_org_invoice_num
2972: AND dii.project_id = di.project_id
2973: AND dii.draft_invoice_num = di.draft_invoice_num
3331: agr.customer_id customer_id,
3332: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3333: dii.inv_amount inv_amount
3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3335: pa_agreements_all agr,
3336: pa_proj_retn_rules rtn
3337: WHERE di.project_id = p_project_id
3338: AND di.draft_invoice_num = p_draft_invoice_num
3339: AND di.agreement_id = agr.agreement_id
3455: agr.customer_id customer_id,
3456: rtn.task_id rtn_task_id
3457: FROM pa_draft_invoice_items dii,
3458: pa_draft_invoices_all di,
3459: pa_agreements_all agr,
3460: pa_proj_retn_rules rtn
3461: WHERE di.project_id = p_project_id
3462: AND di.draft_invoice_num = p_draft_invoice_num
3463: AND di.agreement_id = agr.agreement_id
3538: agr.customer_id customer_id,
3539: NVL(rtn.task_id,dii.task_id) rtn_task_id
3540: FROM pa_draft_invoice_items dii,
3541: pa_draft_invoices_all di,
3542: pa_agreements_all agr,
3543: pa_proj_retn_rules rtn
3544: WHERE di.project_id = p_project_id
3545: AND di.draft_invoice_num = p_draft_invoice_num
3546: AND di.agreement_id = agr.agreement_id
3645: agr.customer_id customer_id,
3646: rtn.task_id rtn_task_id
3647: FROM pa_draft_invoice_items dii,
3648: pa_draft_invoices_all di,
3649: pa_agreements_all agr,
3650: pa_proj_retn_rules rtn
3651: WHERE di.project_id = p_project_id
3652: AND di.draft_invoice_num = p_draft_invoice_num
3653: AND di.agreement_id = agr.agreement_id
3695: agr.customer_id customer_id,
3696: dii.task_id dii_task_id
3697: FROM pa_draft_invoice_items dii,
3698: pa_draft_invoices_all di,
3699: pa_agreements_all agr
3700: WHERE di.project_id = p_project_id
3701: AND di.draft_invoice_num = p_draft_invoice_num
3702: AND di.agreement_id = agr.agreement_id
3703: AND di.project_id = dii.project_id