DBA Data[Home] [Help]

APPS.QP_CUST_MERGE dependencies on RA_CUSTOMER_MERGES

Line 58: FROM OE_AGREEMENTS_B yt, ra_customer_merges m

54: SELECT distinct CUSTOMER_MERGE_HEADER_ID
55: ,agreement_id
56: ,invoice_to_org_id
57: ,sold_to_org_id
58: FROM OE_AGREEMENTS_B yt, ra_customer_merges m
59: WHERE yt.invoice_to_org_id = m.DUPLICATE_SITE_ID
60: AND m.process_flag = 'N'
61: AND m.request_id = req_id
62: AND m.set_number = set_num

Line 68: FROM OE_AGREEMENTS_B yt, ra_customer_merges m

64: SELECT distinct CUSTOMER_MERGE_HEADER_ID
65: ,agreement_id
66: ,invoice_to_org_id
67: ,sold_to_org_id
68: FROM OE_AGREEMENTS_B yt, ra_customer_merges m
69: WHERE yt.sold_to_org_id = m.DUPLICATE_ID
70: AND m.process_flag = 'N'
71: AND m.request_id = req_id
72: AND m.set_number = set_num;

Line 276: FROM QP_QUALIFIERS yt, ra_customer_merges m

272: --Added following 3 select list columns for bug fix 3649761
273: ,qualifier_attr_value
274: ,qualifier_context
275: ,qualifier_attribute
276: FROM QP_QUALIFIERS yt, ra_customer_merges m
277: WHERE
278: /* (
279: yt.qualifier_attr_value = to_char(m.DUPLICATE_SITE_ID)
280: )*/