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_CHECK_UTIL dependencies on RA_TERMS_B

Line 53: --| added join between ra_terms_b and oe_order_lines|

49: --| Jan-15-2004 vto 3364726. Check G_crmgmt_installed directly |
50: --| instead of = TRUE. Removed some unnec NVLs |
51: --| Jan-16-2004 tsimmond Bug fix #3377881. In get_transaction_amount |
52: --| for order level credit check in sql statmnts|
53: --| added join between ra_terms_b and oe_order_lines|
54: --| t.term_id = l.payment_term_id |
55: --| Jan-21-2004 vto 3388857. Current order should not be limited |
56: --| by shipping horizon. |
57: --| Feb-05-2004 vto 3426436: Fix 3377881 as it is complete. |

Line 2404: , ra_terms_b trm

2400: , ln.tax_value tax_value
2401: FROM
2402: OE_ORDER_LINES ln
2403: , mtl_item_categories ctg
2404: , ra_terms_b trm
2405: WHERE ln.header_id = p_header_id
2406: AND ln.invoice_to_org_id = NVL(l_site_use_id, ln.invoice_to_org_id )
2407: AND ln.open_flag = 'Y'
2408: AND (ln.invoiced_quantity IS NULL OR ln.invoiced_quantity = 0)

Line 4552: ra_terms_b t,

4548: )
4549: INTO l_order_value
4550: FROM oe_order_lines l,
4551: oe_order_headers_all h,
4552: ra_terms_b t,
4553: HZ_CUST_SITE_USES_ALL su,
4554: HZ_CUST_ACCT_SITES_ALL cas
4555: WHERE h.header_id = p_header_id
4556: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */

Line 4595: ra_terms_b t,

4591: ))
4592: INTO l_order_value
4593: FROM oe_order_lines l,
4594: oe_order_headers_all h,
4595: ra_terms_b t,
4596: HZ_CUST_SITE_USES_ALL su,
4597: HZ_CUST_ACCT_SITES_ALL cas
4598: WHERE h.header_id = p_header_id
4599: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */

Line 4639: ra_terms_b t

4635: INTO l_commitment
4636: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4637: HZ_CUST_SITE_USES_ALL su,
4638: HZ_CUST_ACCT_SITES_ALL cas,
4639: ra_terms_b t
4640: WHERE h.header_id = p_header_id
4641: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4642: AND h.header_id = l.header_id
4643: AND l.invoice_to_org_id = su.site_use_id

Line 4704: ra_terms_b t,

4700: )
4701: INTO l_freights
4702: FROM oe_order_lines l,
4703: oe_order_headers_all h,
4704: ra_terms_b t,
4705: HZ_CUST_SITE_USES_ALL su,
4706: HZ_CUST_ACCT_SITES_ALL cas,
4707: oe_price_adjustments p
4708: WHERE h.header_id = p_header_id

Line 4764: ra_terms_b t,

4760: )
4761: INTO l_freights
4762: FROM oe_order_lines l,
4763: oe_order_headers_all h,
4764: ra_terms_b t,
4765: HZ_CUST_SITE_USES_ALL su,
4766: HZ_CUST_ACCT_SITES_ALL cas,
4767: oe_price_adjustments p
4768: WHERE h.header_id = p_header_id

Line 4827: ra_terms_b t

4823: )
4824: INTO l_order_value
4825: FROM oe_order_lines l,
4826: oe_order_headers_all h,
4827: ra_terms_b t
4828: WHERE h.header_id = p_header_id
4829: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4830: AND h.header_id = l.header_id
4831: AND l.invoice_to_org_id = p_site_use_id

Line 4865: ra_terms_b t

4861: )
4862: INTO l_order_value
4863: FROM oe_order_lines l,
4864: oe_order_headers_all h,
4865: ra_terms_b t
4866: WHERE h.header_id = p_header_id
4867: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4868: AND h.header_id = l.header_id
4869: AND l.invoice_to_org_id = p_site_use_id

Line 4899: ra_terms_b t

4895: INTO l_commitment
4896: FROM OE_PAYMENTS P,
4897: OE_ORDER_HEADERS_ALL H,
4898: OE_ORDER_LINES L,
4899: ra_terms_b t
4900: WHERE h.header_id = p_header_id
4901: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4902: AND h.header_id = l.header_id
4903: AND l.invoice_to_org_id = p_site_use_id

Line 4963: ra_terms_b t,

4959: )
4960: INTO l_freights
4961: FROM oe_order_lines l,
4962: oe_order_headers_all h,
4963: ra_terms_b t,
4964: oe_price_adjustments p
4965: WHERE h.header_id = p_header_id
4966: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4967: AND h.header_id = l.header_id

Line 5020: ra_terms_b t,

5016: )
5017: INTO l_freights
5018: FROM oe_order_lines l,
5019: oe_order_headers_all h,
5020: ra_terms_b t,
5021: oe_price_adjustments p
5022: WHERE h.header_id = p_header_id
5023: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5024: AND h.header_id = l.header_id

Line 5081: ra_terms_b t

5077: )
5078: INTO l_order_value
5079: FROM oe_order_lines l,
5080: oe_order_headers_all h,
5081: ra_terms_b t
5082: WHERE h.header_id = p_header_id
5083: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5084: AND h.header_id = l.header_id
5085: --ER 12363706 AND l.open_flag = 'Y'

Line 5118: ra_terms_b t

5114: )
5115: INTO l_order_value
5116: FROM oe_order_lines l,
5117: oe_order_headers_all h,
5118: ra_terms_b t
5119: WHERE h.header_id = p_header_id
5120: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5121: AND h.header_id = l.header_id
5122: --ER 12363706 AND l.open_flag = 'Y'

Line 5157: ra_terms_b t,

5153: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5154: INTO l_commitment
5155: FROM oe_order_lines l,
5156: oe_order_headers_all h,
5157: ra_terms_b t,
5158: oe_payments p
5159: WHERE h.header_id = p_header_id
5160: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5161: AND h.header_id = l.header_id

Line 5241: , ra_terms_b t

5237: INTO l_freights_hdr_1
5238: FROM oe_price_adjustments p
5239: , oe_order_lines l
5240: , oe_order_headers_all h
5241: , ra_terms_b t
5242: WHERE h.header_id = p_header_id
5243: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5244: AND p.line_id = l.line_id
5245: AND p.header_id = l.header_id

Line 5319: , ra_terms_b t

5315: INTO l_freights_hdr_1
5316: FROM oe_price_adjustments p
5317: , oe_order_lines l
5318: , oe_order_headers_all h
5319: , ra_terms_b t
5320: WHERE h.header_id = p_header_id
5321: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5322: AND p.line_id = l.line_id
5323: AND p.header_id = l.header_id