[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT c.credit_type_code,
c.salesrep_id,
c.credit_percentage,
p.segment1 proj_num,
pt.cc_prvdr_flag ic_flag,
(select 'Y' from dual where exists (select 1 from pa_project_customers pc
where pc.project_id = p.project_id
and pc.bill_another_project_flag='Y')) ip_flag /* Added for bug 6603869*/
FROM pa_credit_receivers c,
pa_projects p,
so_sales_credit_types sc,
pa_project_types pt
WHERE c.project_id = p.project_id
AND c.project_id = pj_id
AND c.transfer_to_ar_flag = 'Y'
AND c.credit_type_code = sc.name
AND sc.enabled_flag = 'Y'
AND p.project_type = pt.project_type
ORDER BY c.credit_type_code, c.credit_percentage;
SELECT a.salesrep_id,
c.segment1 proj_num,
I.sales_credit_type_code credit_type,
pt.cc_prvdr_flag ic_flag
FROM ra_salesreps a,
pa_project_players b,
pa_projects c,
pa_implementations I,
pa_project_types pt
WHERE c.project_id = b.project_id
AND b.project_id = pj_id
AND b.project_role_type = 'PROJECT MANAGER'
AND b.person_id = a.person_id
AND trunc(SYSDATE) BETWEEN b.Start_Date_Active (+)
AND NVL(b.End_Date_Active (+), trunc(SYSDATE))
AND c.project_type = pt.project_type;
SELECT interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
r.allow_sales_credit_flag
FROM
ra_interface_lines i,
pa_draft_invoices inv,
pa_implementations p,
ra_batch_sources r
WHERE
inv.project_id = pj_id
-- AND inv.draft_invoice_num = to_number(interface_line_attribute2) commented for bug 5330841
AND to_char(inv.draft_invoice_num) = trim(interface_line_attribute2) /* Added for bug 5330841 */
AND inv.request_id = req_id
AND i.interface_line_attribute1 = project_number
AND i.batch_source_name = r.name
AND r.batch_source_id = p.invoice_batch_source_id
AND i.interface_status IS NULL
;
SELECT interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
r.allow_sales_credit_flag
FROM
ra_interface_lines i,
pa_draft_invoices inv,
pa_implementations p,
ra_batch_sources r
WHERE
inv.project_id = pj_id
-- AND inv.draft_invoice_num = to_number(interface_line_attribute2)commented for bug 5330841
AND to_char(inv.draft_invoice_num) = trim(interface_line_attribute2) /* Added for bug 5330841 */
AND inv.request_id = req_id
AND i.interface_line_attribute1 = project_number
AND i.batch_source_name = r.name
AND r.batch_source_id = nvl(p.cc_ic_ar_batch_source_id,0)
AND i.interface_status IS NULL
;
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_rec.salesrep_id,
credit_rec.credit_type_code,
credit_rec.credit_percentage,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_rec.salesrep_id,
credit_rec.credit_type_code,
credit_rec.credit_percentage,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_rec.salesrep_id,
credit_rec.credit_type_code,
credit_rec.credit_percentage,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_def_rec.salesrep_id,
credit_def_rec.credit_type,
100,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_def_rec.salesrep_id,
credit_def_rec.credit_type,
100,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
INSERT INTO ra_interface_salescredits
(interface_line_context,
interface_line_attribute1,
interface_line_attribute2,
interface_line_attribute3,
interface_line_attribute4,
interface_line_attribute5,
interface_line_attribute6,
interface_line_attribute7,
salesrep_id,
sales_credit_type_name,
sales_credit_percent_split,
org_id)
VALUES (int_rec.interface_line_context,
int_rec.interface_line_attribute1,
int_rec.interface_line_attribute2,
int_rec.interface_line_attribute3,
int_rec.interface_line_attribute4,
int_rec.interface_line_attribute5,
int_rec.interface_line_attribute6,
int_rec.interface_line_attribute7,
credit_rec.salesrep_id,
credit_rec.credit_type_code,
credit_rec.credit_percentage,
PA_MOAC_UTILS.GET_CURRENT_ORG_ID);
SELECT r.allow_sales_credit_flag
FROM ra_batch_sources r,
pa_implementations i
WHERE i.invoice_batch_source_id = r.batch_source_id;
select 'x'
into l_dummy
from dual
where exists ( select 1
from pa_implementations i,
so_sales_credit_types sc
where i.sales_credit_type_code = sc.name
and sc.enabled_flag = 'Y'
UNION ALL
select 1
from pa_credit_receivers
WHERE project_id = pj_id
AND transfer_to_ar_flag = 'Y'
AND ROWNUM = 1 );
SELECT 'x'
INTO l_dummy
FROM pa_credit_receivers
WHERE project_id = pj_id
AND transfer_to_ar_flag = 'Y'
AND ROWNUM = 1 ;
SELECT 'x'
INTO l_dummy
FROM sys.dual
WHERE exists ( select 'x'
from pa_credit_receivers c,
so_sales_credit_types sc
where c.project_id = pj_id
and c.credit_type_code = sc.name
and c.transfer_to_ar_flag = 'Y'
and sc.enabled_flag = 'Y' );
select 'x'
into l_dummy
from dual
where exists ( select 1
from pa_Credit_receivers
where project_id = pj_id
AND transfer_to_Ar_flag = 'Y'
AND sysdate between start_date_Active and end_date_Active
); */
select 'x'
into l_dummy
from dual
where exists ( select 1
from pa_implementations i,
pa_lookups pa
where pa.lookup_type='CREDIT TYPE'
and i.sales_credit_type_code = pa.lookup_code
and pa.enabled_flag = 'Y'
UNION ALL
select 1
from pa_credit_receivers
WHERE project_id = pj_id
AND transfer_to_ar_flag = 'Y'
AND ROWNUM = 1 );
SELECT 'x'
INTO l_dummy
FROM pa_credit_receivers
WHERE project_id = pj_id
AND transfer_to_ar_flag = 'Y'
AND ROWNUM = 1 ;
SELECT 'x'
INTO l_dummy
FROM sys.dual
WHERE exists ( select 'x'
from pa_credit_receivers c,
pa_lookups pa
where c.project_id = pj_id
and pa.lookup_type='CREDIT TYPE'
and c.credit_type_code = pa.lookup_code
and c.transfer_to_ar_flag = 'Y'
and pa.enabled_flag = 'Y' );
select 'x'
into l_dummy
from dual
where exists ( select 1
from pa_Credit_receivers
where project_id = pj_id
AND transfer_to_Ar_flag = 'Y'
AND sysdate between start_date_active and end_date_Active
); */