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_HOLDS_PVT dependencies on HZ_CUST_SITE_USES

Line 1970: FROM hz_cust_site_uses -- Bug 2138398

1966:
1967: ELSIF p_hold_source_rec.hold_entity_code = 'S' THEN
1968: SELECT 'Valid Entity'
1969: INTO l_dummy
1970: FROM hz_cust_site_uses -- Bug 2138398
1971: WHERE site_use_id = p_hold_source_rec.hold_entity_id
1972: AND site_use_code = 'SHIP_TO'
1973: AND STATUS='A';
1974:

Line 1987: FROM hz_cust_site_uses -- Bug 2138398

1983:
1984: ELSIF p_hold_source_rec.hold_entity_code = 'B' THEN
1985: SELECT 'Valid Entity'
1986: INTO l_dummy
1987: FROM hz_cust_site_uses -- Bug 2138398
1988: WHERE site_use_id = p_hold_source_rec.hold_entity_id
1989: AND site_use_code = 'BILL_TO'
1990: AND STATUS='A';
1991: --ER#7479609 start

Line 1995: FROM hz_cust_site_uses

1991: --ER#7479609 start
1992: ELSIF p_hold_source_rec.hold_entity_code = 'D' THEN
1993: SELECT 'Valid Entity'
1994: INTO l_dummy
1995: FROM hz_cust_site_uses
1996: WHERE site_use_id = p_hold_source_rec.hold_entity_id
1997: AND site_use_code = 'DELIVER_TO'
1998: AND STATUS='A';
1999: --ER#7479609 end

Line 2106: FROM hz_cust_site_uses -- Bug 2138398

2102:
2103: ELSIF p_hold_source_rec.hold_entity_code2 = 'S' THEN
2104: SELECT 'Valid Entity'
2105: INTO l_dummy
2106: FROM hz_cust_site_uses -- Bug 2138398
2107: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2108: AND site_use_code = 'SHIP_TO';
2109:
2110:

Line 2122: FROM hz_cust_site_uses -- Bug 2138398

2118:
2119: ELSIF p_hold_source_rec.hold_entity_code2 = 'B' THEN
2120: SELECT 'Valid Entity'
2121: INTO l_dummy
2122: FROM hz_cust_site_uses -- Bug 2138398
2123: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2124: AND site_use_code = 'BILL_TO';
2125: ELSIF p_hold_source_rec.hold_entity_code2 = 'H' THEN
2126: SELECT 'Valid Entity'

Line 2151: FROM hz_cust_site_uses

2147: WHERE user_id = p_hold_source_rec.hold_entity_id2;
2148: ELSIF p_hold_source_rec.hold_entity_code2 = 'D' THEN
2149: SELECT 'Valid Entity'
2150: INTO l_dummy
2151: FROM hz_cust_site_uses
2152: WHERE SITE_USE_ID = p_hold_source_rec.hold_entity_id2
2153: AND site_use_code = 'DELIVER_TO';
2154: ELSIF p_hold_source_rec.hold_entity_code2 in ('LT','OT') THEN
2155: SELECT 'Valid Entity'