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_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 5775: , hz_cust_acct_sites_all s

5771: -999 interface_line_attribute6 --TaxER
5772: from oe_order_lines_all l
5773: , oe_order_headers_all h
5774: , hz_cust_site_uses_all su
5775: , hz_cust_acct_sites_all s
5776: , hz_cust_accounts ca
5777: , hz_cust_site_uses_all su_l
5778: , hz_cust_acct_sites_all s_l
5779: , hz_cust_accounts ca_l

Line 5778: , hz_cust_acct_sites_all s_l

5774: , hz_cust_site_uses_all su
5775: , hz_cust_acct_sites_all s
5776: , hz_cust_accounts ca
5777: , hz_cust_site_uses_all su_l
5778: , hz_cust_acct_sites_all s_l
5779: , hz_cust_accounts ca_l
5780: where h.header_id = l.header_id
5781: AND h.booked_flag = 'Y'
5782: AND h.open_flag = 'Y'

Line 5860: , hz_cust_acct_sites_all s

5856: DECODE(OE_CREDIT_EXPOSURE_PVT.Is_Equal(rl.interface_line_attribute6,l.line_id),'Y',-999,to_number(rl.interface_line_attribute6)) interface_line_attribute6 --TaxER
5857: from oe_order_lines_all l
5858: , oe_order_headers_all h
5859: , hz_cust_site_uses_all su
5860: , hz_cust_acct_sites_all s
5861: , hz_cust_accounts ca
5862: , hz_cust_site_uses_all su_l
5863: , hz_cust_acct_sites_all s_l
5864: , hz_cust_accounts ca_l

Line 5863: , hz_cust_acct_sites_all s_l

5859: , hz_cust_site_uses_all su
5860: , hz_cust_acct_sites_all s
5861: , hz_cust_accounts ca
5862: , hz_cust_site_uses_all su_l
5863: , hz_cust_acct_sites_all s_l
5864: , hz_cust_accounts ca_l
5865: , ra_interface_lines_all rl
5866: where h.header_id = l.header_id
5867: AND h.booked_flag = 'Y'

Line 7214: , hz_cust_acct_sites_all s

7210: FROM
7211: oe_price_adjustments p
7212: , oe_order_headers_all h
7213: , hz_cust_site_uses_all su
7214: , hz_cust_acct_sites_all s
7215: , hz_cust_accounts ca
7216: WHERE
7217: p.line_id IS NULL
7218: AND p.header_id = h.header_id

Line 7273: , hz_cust_acct_sites_all s

7269: FROM
7270: oe_price_adjustments p
7271: , oe_order_headers_all h
7272: , hz_cust_site_uses_all su
7273: , hz_cust_acct_sites_all s
7274: , hz_cust_accounts ca
7275: , ra_interface_lines_all rl
7276: WHERE
7277: p.line_id IS NULL

Line 7369: , hz_cust_acct_sites_all s

7365: FROM
7366: oe_price_adjustments p
7367: , oe_order_headers_all h
7368: , hz_cust_site_uses_all su
7369: , hz_cust_acct_sites_all s
7370: , hz_cust_accounts ca
7371: WHERE
7372: p.line_id IS NULL
7373: AND p.header_id = h.header_id

Line 7430: , hz_cust_acct_sites_all s

7426: FROM
7427: oe_price_adjustments p
7428: , oe_order_headers_all h
7429: , hz_cust_site_uses_all su
7430: , hz_cust_acct_sites_all s
7431: , hz_cust_accounts ca
7432: , ra_interface_lines_all rl
7433: WHERE
7434: p.line_id IS NULL

Line 7542: , hz_cust_acct_sites_all s

7538: FROM
7539: oe_price_adjustments p
7540: , oe_order_headers_all h
7541: , hz_cust_site_uses_all su
7542: , hz_cust_acct_sites_all s
7543: , hz_cust_accounts ca
7544: WHERE
7545: p.line_id IS NULL
7546: AND p.header_id = h.header_id

Line 7600: , hz_cust_acct_sites_all s

7596: FROM
7597: oe_price_adjustments p
7598: , oe_order_headers_all h
7599: , hz_cust_site_uses_all su
7600: , hz_cust_acct_sites_all s
7601: , hz_cust_accounts ca
7602: , ra_interface_lines_all rl
7603: WHERE
7604: p.line_id IS NULL

Line 7693: , hz_cust_acct_sites_all s

7689: FROM
7690: oe_price_adjustments p
7691: , oe_order_headers_all h
7692: , hz_cust_site_uses_all su
7693: , hz_cust_acct_sites_all s
7694: , hz_cust_accounts ca
7695: WHERE
7696: p.line_id IS NULL
7697: AND p.header_id = h.header_id

Line 7753: , hz_cust_acct_sites_all s

7749: FROM
7750: oe_price_adjustments p
7751: , oe_order_headers_all h
7752: , hz_cust_site_uses_all su
7753: , hz_cust_acct_sites_all s
7754: , hz_cust_accounts ca
7755: , ra_interface_lines_all rl
7756: WHERE
7757: p.line_id IS NULL

Line 8045: , hz_cust_acct_sites_all s

8041: oe_order_lines_all l
8042: , oe_order_headers_all h
8043: , oe_payments p
8044: , hz_cust_site_uses_all su
8045: , hz_cust_acct_sites_all s
8046: , hz_cust_accounts ca
8047: WHERE
8048: h.header_id = l.header_id
8049:

Line 9285: , hz_cust_acct_sites_all s

9281: FROM
9282: oe_price_adjustments p
9283: , oe_order_headers_all h
9284: , hz_cust_site_uses_all su
9285: , hz_cust_acct_sites_all s
9286: , hz_cust_accounts ca
9287: WHERE
9288: p.line_id IS NULL
9289: AND p.header_id = h.header_id

Line 9380: , hz_cust_acct_sites_all s

9376: FROM
9377: oe_price_adjustments p
9378: , oe_order_headers_all h
9379: , hz_cust_site_uses_all su
9380: , hz_cust_acct_sites_all s
9381: , hz_cust_accounts ca
9382: WHERE
9383: p.line_id IS NULL
9384: AND p.header_id = h.header_id

Line 9488: , hz_cust_acct_sites_all s

9484: FROM
9485: oe_price_adjustments p
9486: , oe_order_headers_all h
9487: , hz_cust_site_uses_all su
9488: , hz_cust_acct_sites_all s
9489: , hz_cust_accounts ca
9490: WHERE
9491: p.line_id IS NULL
9492: AND p.header_id = h.header_id

Line 9582: , hz_cust_acct_sites_all s

9578: FROM
9579: oe_price_adjustments p
9580: , oe_order_headers_all h
9581: , hz_cust_site_uses_all su
9582: , hz_cust_acct_sites_all s
9583: , hz_cust_accounts ca
9584: WHERE
9585: p.line_id IS NULL
9586: AND p.header_id = h.header_id