eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_UTIL dependencies on OE_DELIVER_TO_ORGS_V

Line 210: FROM oe_deliver_to_orgs_v

206:
207: IF g_customer_relations = 'N' THEN
208: SELECT 'VALID'
209: INTO l_dummy
210: FROM oe_deliver_to_orgs_v
211: WHERE customer_id = p_sold_to_org_id
212: AND site_use_id = p_deliver_to_org_id
213: AND status = 'A'
214: AND address_status ='A';--bug 2752321

Line 255: FROM OE_DELIVER_TO_ORGS_V DEL

251: ELSIF g_customer_relations = 'A' THEN
252:
253: SELECT 'VALID'
254: INTO l_dummy
255: FROM OE_DELIVER_TO_ORGS_V DEL
256: WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
257: AND DEL.STATUS = 'A'
258: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
259: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)

Line 9556: FROM oe_deliver_to_orgs_v

9552: if mc1x.deliver_to_org_id is not null then
9553: -- Deliver to
9554: BEGIN
9555: SELECT 'VALID' INTO l_dummy
9556: FROM oe_deliver_to_orgs_v
9557: WHERE customer_id = p_sold_to_org_id
9558: AND site_use_id = mc1x.deliver_to_org_id
9559: AND status = 'A'
9560: and address_status='A'; --2752321