APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on OE_SALES_CREDIT_TYPES

Line 137: from oe_sales_credit_types sc_typ,

133: sc.sales_credit_id, sc.percent, sc.sales_credit_type_id,
134: sc.salesrep_id, sc.header_id, sc.line_id, sr.resource_id,
135: sr.org_id, sc.sales_group_id group_id, sc.created_by, sc.creation_date,
136: sc.last_updated_by, sc.last_update_date, sc.last_update_login
137: from oe_sales_credit_types sc_typ,
138: oe_sales_credits sc,
139: jtf_rs_salesreps sr
140: where sc.sales_group_id is not null
141: and sc.salesrep_id = sr.salesrep_id

Line 151: from oe_sales_credit_types sc_typ,

147: sc.sales_credit_id, sc.percent, sc.sales_credit_type_id,
148: sc.salesrep_id, sc.header_id, sc.line_id, sg.resource_id,
149: sg.org_id, sg.group_id, sc.created_by, sc.creation_date,
150: sc.last_updated_by, sc.last_update_date, sc.last_update_login
151: from oe_sales_credit_types sc_typ,
152: oe_sales_credits sc,
153: jtf_rs_srp_groups sg
154: where sc.sales_group_id is null
155: and sc.salesrep_id = sg.salesrep_id

Line 2855: from oe_sales_credit_types sc_typ,

2851: sc.sales_credit_id, sc.percent, sc.sales_credit_type_id,
2852: sc.salesrep_id, sc.header_id, sc.line_id, sr.resource_id,
2853: sr.org_id, sc.sales_group_id group_id, sc.created_by, sc.creation_date,
2854: sc.last_updated_by, sc.last_update_date, sc.last_update_login
2855: from oe_sales_credit_types sc_typ,
2856: oe_sales_credits sc,
2857: jtf_rs_salesreps sr
2858: where sc.sales_group_id is not null
2859: and sc.salesrep_id = sr.salesrep_id

Line 2869: from oe_sales_credit_types sc_typ,

2865: sc.sales_credit_id, sc.percent, sc.sales_credit_type_id,
2866: sc.salesrep_id, sc.header_id, sc.line_id, sg.resource_id,
2867: sg.org_id, sg.group_id, sc.created_by, sc.creation_date,
2868: sc.last_updated_by, sc.last_update_date, sc.last_update_login
2869: from oe_sales_credit_types sc_typ,
2870: oe_sales_credits sc,
2871: jtf_rs_srp_groups sg
2872: where sc.sales_group_id is null
2873: and sc.salesrep_id = sg.salesrep_id