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 121: FROM oe_deliver_to_orgs_v

117:
118: IF g_customer_relations = 'N' THEN
119: SELECT 'VALID'
120: INTO l_dummy
121: FROM oe_deliver_to_orgs_v
122: WHERE customer_id = p_sold_to_org_id
123: AND site_use_id = p_deliver_to_org_id
124: AND status = 'A'
125: AND address_status ='A';--bug 2752321

Line 166: FROM OE_DELIVER_TO_ORGS_V DEL

162: ELSIF g_customer_relations = 'A' THEN
163:
164: SELECT 'VALID'
165: INTO l_dummy
166: FROM OE_DELIVER_TO_ORGS_V DEL
167: WHERE DEL.ORGANIZATION_ID =p_deliver_to_org_id
168: AND DEL.STATUS = 'A'
169: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
170: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)

Line 9359: FROM oe_deliver_to_orgs_v

9355: if mc1x.deliver_to_org_id is not null then
9356: -- Deliver to
9357: BEGIN
9358: SELECT 'VALID' INTO l_dummy
9359: FROM oe_deliver_to_orgs_v
9360: WHERE customer_id = p_sold_to_org_id
9361: AND site_use_id = mc1x.deliver_to_org_id
9362: AND status = 'A'
9363: and address_status='A'; --2752321