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 4396: ra_terms_b t,

4392: )
4393: INTO l_order_value
4394: FROM oe_order_lines l,
4395: oe_order_headers_all h,
4396: ra_terms_b t,
4397: HZ_CUST_SITE_USES_ALL su,
4398: HZ_CUST_ACCT_SITES_ALL cas
4399: WHERE h.header_id = p_header_id
4400: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */

Line 4438: ra_terms_b t,

4434: ))
4435: INTO l_order_value
4436: FROM oe_order_lines l,
4437: oe_order_headers_all h,
4438: ra_terms_b t,
4439: HZ_CUST_SITE_USES_ALL su,
4440: HZ_CUST_ACCT_SITES_ALL cas
4441: WHERE h.header_id = p_header_id
4442: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */

Line 4481: ra_terms_b t

4477: INTO l_commitment
4478: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4479: HZ_CUST_SITE_USES_ALL su,
4480: HZ_CUST_ACCT_SITES_ALL cas,
4481: ra_terms_b t
4482: WHERE h.header_id = p_header_id
4483: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4484: AND h.header_id = l.header_id
4485: AND l.invoice_to_org_id = su.site_use_id

Line 4542: ra_terms_b t,

4538: )
4539: INTO l_freights
4540: FROM oe_order_lines l,
4541: oe_order_headers_all h,
4542: ra_terms_b t,
4543: HZ_CUST_SITE_USES_ALL su,
4544: HZ_CUST_ACCT_SITES_ALL cas,
4545: oe_price_adjustments p
4546: WHERE h.header_id = p_header_id

Line 4597: ra_terms_b t,

4593: )
4594: INTO l_freights
4595: FROM oe_order_lines l,
4596: oe_order_headers_all h,
4597: ra_terms_b t,
4598: HZ_CUST_SITE_USES_ALL su,
4599: HZ_CUST_ACCT_SITES_ALL cas,
4600: oe_price_adjustments p
4601: WHERE h.header_id = p_header_id

Line 4658: ra_terms_b t

4654: )
4655: INTO l_order_value
4656: FROM oe_order_lines l,
4657: oe_order_headers_all h,
4658: ra_terms_b t
4659: WHERE h.header_id = p_header_id
4660: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4661: AND h.header_id = l.header_id
4662: AND l.invoice_to_org_id = p_site_use_id

Line 4695: ra_terms_b t

4691: )
4692: INTO l_order_value
4693: FROM oe_order_lines l,
4694: oe_order_headers_all h,
4695: ra_terms_b t
4696: WHERE h.header_id = p_header_id
4697: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4698: AND h.header_id = l.header_id
4699: AND l.invoice_to_org_id = p_site_use_id

Line 4728: ra_terms_b t

4724: INTO l_commitment
4725: FROM OE_PAYMENTS P,
4726: OE_ORDER_HEADERS_ALL H,
4727: OE_ORDER_LINES L,
4728: ra_terms_b t
4729: WHERE h.header_id = p_header_id
4730: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4731: AND h.header_id = l.header_id
4732: AND l.invoice_to_org_id = p_site_use_id

Line 4788: ra_terms_b t,

4784: )
4785: INTO l_freights
4786: FROM oe_order_lines l,
4787: oe_order_headers_all h,
4788: ra_terms_b t,
4789: oe_price_adjustments p
4790: WHERE h.header_id = p_header_id
4791: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4792: AND h.header_id = l.header_id

Line 4840: ra_terms_b t,

4836: )
4837: INTO l_freights
4838: FROM oe_order_lines l,
4839: oe_order_headers_all h,
4840: ra_terms_b t,
4841: oe_price_adjustments p
4842: WHERE h.header_id = p_header_id
4843: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4844: AND h.header_id = l.header_id

Line 4899: ra_terms_b t

4895: )
4896: INTO l_order_value
4897: FROM oe_order_lines l,
4898: oe_order_headers_all h,
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.open_flag = 'Y'

Line 4935: ra_terms_b t

4931: )
4932: INTO l_order_value
4933: FROM oe_order_lines l,
4934: oe_order_headers_all h,
4935: ra_terms_b t
4936: WHERE h.header_id = p_header_id
4937: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4938: AND h.header_id = l.header_id
4939: AND l.open_flag = 'Y'

Line 4973: ra_terms_b t,

4969: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4970: INTO l_commitment
4971: FROM oe_order_lines l,
4972: oe_order_headers_all h,
4973: ra_terms_b t,
4974: oe_payments p
4975: WHERE h.header_id = p_header_id
4976: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4977: AND h.header_id = l.header_id

Line 5053: , ra_terms_b t

5049: INTO l_freights_hdr_1
5050: FROM oe_price_adjustments p
5051: , oe_order_lines l
5052: , oe_order_headers_all h
5053: , ra_terms_b t
5054: WHERE h.header_id = p_header_id
5055: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5056: AND p.line_id = l.line_id
5057: AND p.header_id = l.header_id

Line 5122: , ra_terms_b t

5118: INTO l_freights_hdr_1
5119: FROM oe_price_adjustments p
5120: , oe_order_lines l
5121: , oe_order_headers_all h
5122: , ra_terms_b t
5123: WHERE h.header_id = p_header_id
5124: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5125: AND p.line_id = l.line_id
5126: AND p.header_id = l.header_id