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 OE_ORDER_LINES_ALL

Line 5827: FROM oe_order_lines_all l

5823: ( l.ordered_quantity * l.unit_selling_price )
5824: + DECODE(l_include_tax_flag, 'Y',
5825: NVL(l.tax_value,0), 0 )
5826: )
5827: FROM oe_order_lines_all l
5828: , oe_order_headers h
5829: , hz_cust_site_uses_all su
5830: , hz_cust_acct_sites_all cas
5831: WHERE h.invoice_to_org_id = su.site_use_id

Line 6534: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)

6530: AND oh.hold_release_id IS NULL )
6531: AND EXISTS
6532: (SELECT NULL
6533: FROM oe_payment_types_all pt,
6534: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6535: WHERE pt.credit_check_flag = 'Y'
6536: AND l.header_id = h.header_id
6537: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6538: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6579: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)

6575: AND oh.hold_release_id IS NULL )
6576: AND EXISTS
6577: (SELECT NULL
6578: FROM oe_payment_types_all pt,
6579: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6580: WHERE pt.credit_check_flag = 'Y'
6581: AND l.header_id = h.header_id
6582: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6583: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6623: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)

6619: AND oh.hold_release_id IS NULL )
6620: AND EXISTS
6621: (SELECT NULL
6622: FROM oe_payment_types_all pt,
6623: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6624: WHERE pt.credit_check_flag = 'Y'
6625: AND l.header_id = h.header_id
6626: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6627: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 7717: FROM oe_order_lines_ALL l

7713: ( l.ordered_quantity * l.unit_selling_price )
7714: + DECODE(l_include_tax_flag, 'Y',
7715: NVL(l.tax_value,0), 0 )
7716: )
7717: FROM oe_order_lines_ALL l
7718: , oe_order_headers_ALL h
7719: , hz_cust_site_uses_ALL su
7720: , hz_cust_acct_sites_ALL cas
7721: WHERE h.invoice_to_org_id = su.site_use_id

Line 7756: FROM oe_order_lines_ALL l

7752: * l.unit_selling_price )
7753: + DECODE(l_include_tax_flag, 'Y',
7754: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
7755: )
7756: FROM oe_order_lines_ALL l
7757: , oe_order_headers_ALL h
7758: , hz_cust_site_uses_ALL su
7759: , hz_cust_acct_sites_ALL cas
7760: WHERE h.invoice_to_org_id = su.site_use_id

Line 7794: , OE_ORDER_LINES_ALL L

7790: (p_curr_code IN VARCHAR2 default NULL) IS
7791: SELECT NVL(SUM(P.commitment_applied_amount), 0)
7792: FROM OE_PAYMENTS P
7793: , OE_ORDER_HEADERS_ALL H
7794: , OE_ORDER_LINES_ALL L
7795: , hz_cust_site_uses_ALL su
7796: , hz_cust_acct_sites_ALL cas
7797: WHERE H.invoice_to_org_id = su.site_use_id
7798: AND cas.cust_acct_site_id = su.cust_acct_site_id

Line 7833: FROM oe_order_lines_ALL l

7829: ( l.ordered_quantity * l.unit_selling_price )
7830: + DECODE(l_include_tax_flag, 'Y',
7831: NVL(l.tax_value,0), 0 )
7832: )
7833: FROM oe_order_lines_ALL l
7834: , oe_order_headers_ALL h
7835: , hz_cust_site_uses_ALL su
7836: , hz_cust_acct_sites_ALL cas
7837: WHERE h.invoice_to_org_id = su.site_use_id

Line 7876: FROM oe_order_lines_ALL l

7872: * l.unit_selling_price )
7873: + DECODE(l_include_tax_flag, 'Y',
7874: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
7875: )
7876: FROM oe_order_lines_ALL l
7877: , oe_order_headers_ALL h
7878: , hz_cust_site_uses_ALL su
7879: , hz_cust_acct_sites_ALL cas
7880: WHERE h.invoice_to_org_id = su.site_use_id

Line 7915: FROM oe_order_lines_ALL l

7911: ( l.ordered_quantity * l.unit_selling_price )
7912: + DECODE(l_include_tax_flag, 'Y',
7913: NVL(l.tax_value,0), 0 )
7914: )
7915: FROM oe_order_lines_ALL l
7916: , oe_order_headers_ALL h
7917: , hz_cust_site_uses_ALL su
7918: , hz_cust_acct_sites_ALL cas
7919: WHERE h.invoice_to_org_id = su.site_use_id

Line 7957: FROM oe_order_lines_ALL l

7953: * l.unit_selling_price )
7954: + DECODE(l_include_tax_flag, 'Y',
7955: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
7956: )
7957: FROM oe_order_lines_ALL l
7958: , oe_order_headers_ALL h
7959: , hz_cust_site_uses_ALL su
7960: , hz_cust_acct_sites_ALL cas
7961: WHERE h.invoice_to_org_id = su.site_use_id

Line 7999: , oe_order_lines_ALL l

7995: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7996: p.operand, (l.ordered_quantity * p.adjusted_amount))
7997: )
7998: FROM oe_price_adjustments p
7999: , oe_order_lines_ALL l
8000: , oe_order_headers_ALL h
8001: , hz_cust_site_uses_ALL su
8002: , hz_cust_acct_sites_ALL cas
8003: WHERE h.invoice_to_org_id = su.site_use_id

Line 8045: , oe_order_lines_ALL l

8041: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
8042: p.operand, (l.ordered_quantity * p.adjusted_amount))
8043: )
8044: FROM oe_price_adjustments p
8045: , oe_order_lines_ALL l
8046: , oe_order_headers_ALL h
8047: , hz_cust_site_uses_ALL su
8048: , hz_cust_acct_sites_ALL cas
8049: WHERE h.invoice_to_org_id = su.site_use_id

Line 8106: oe_order_lines_all l

8102: AND h.header_id <> l_header_id
8103: AND EXISTS
8104: ( SELECT NULL
8105: FROM oe_payment_types_all t,
8106: oe_order_lines_all l
8107: WHERE t.credit_check_flag = 'Y'
8108: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8109: AND l.header_id = h.header_id
8110: AND t.payment_type_code =

Line 8146: oe_order_lines_all l

8142: AND h.header_id <> l_header_id
8143: AND EXISTS
8144: ( SELECT NULL
8145: FROM oe_payment_types_all t,
8146: oe_order_lines_all l
8147: WHERE t.credit_check_flag = 'Y'
8148: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8149: AND l.header_id = h.header_id
8150: AND t.payment_type_code =

Line 8167: , oe_order_lines_ALL l

8163: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
8164: p.operand, (l.ordered_quantity * p.adjusted_amount))
8165: )
8166: FROM oe_price_adjustments p
8167: , oe_order_lines_ALL l
8168: , oe_order_headers_ALL h
8169: , hz_cust_site_uses_ALL su
8170: , hz_cust_acct_sites_ALL cas
8171: WHERE h.invoice_to_org_id = su.site_use_id

Line 8217: , oe_order_lines_ALL l

8213: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
8214: p.operand, (l.ordered_quantity * p.adjusted_amount))
8215: )
8216: FROM oe_price_adjustments p
8217: , oe_order_lines_ALL l
8218: , oe_order_headers_ALL h
8219: , hz_cust_site_uses_ALL su
8220: , hz_cust_acct_sites_ALL cas
8221: WHERE h.invoice_to_org_id = su.site_use_id

Line 8264: , oe_order_lines_ALL l

8260: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
8261: p.operand, (l.ordered_quantity * p.adjusted_amount))
8262: )
8263: FROM oe_price_adjustments p
8264: , oe_order_lines_ALL l
8265: , oe_order_headers_ALL h
8266: , hz_cust_site_uses_ALL su
8267: , hz_cust_acct_sites_ALL cas
8268: WHERE h.invoice_to_org_id = su.site_use_id

Line 8314: , oe_order_lines_ALL l

8310: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
8311: p.operand, (l.ordered_quantity * p.adjusted_amount))
8312: )
8313: FROM oe_price_adjustments p
8314: , oe_order_lines_ALL l
8315: , oe_order_headers_ALL h
8316: , hz_cust_site_uses_ALL su
8317: , hz_cust_acct_sites_ALL cas
8318: WHERE h.invoice_to_org_id = su.site_use_id

Line 8384: oe_order_lines_all l

8380: AND oh.hold_release_id IS NULL )
8381: AND EXISTS
8382: ( SELECT NULL
8383: FROM oe_payment_types_all t,
8384: oe_order_lines_all l
8385: WHERE t.credit_check_flag = 'Y'
8386: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8387: AND l.header_id = h.header_id
8388: AND t.payment_type_code =

Line 8429: oe_order_lines_all l

8425: AND oh.hold_release_id IS NULL )
8426: AND EXISTS
8427: ( SELECT NULL
8428: FROM oe_payment_types_all t,
8429: oe_order_lines_all l
8430: WHERE t.credit_check_flag = 'Y'
8431: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8432: AND l.header_id = h.header_id
8433: AND t.payment_type_code =

Line 8472: oe_order_lines_all l

8468: AND oh.hold_release_id IS NULL )
8469: AND EXISTS
8470: ( SELECT NULL
8471: FROM oe_payment_types_all t,
8472: oe_order_lines_all l
8473: WHERE t.credit_check_flag = 'Y'
8474: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8475: AND l.header_id = h.header_id
8476: AND t.payment_type_code =

Line 8516: oe_order_lines_all l

8512: AND oh.hold_release_id IS NULL )
8513: AND EXISTS
8514: ( SELECT NULL
8515: FROM oe_payment_types_all t,
8516: oe_order_lines_all l
8517: WHERE t.credit_check_flag = 'Y'
8518: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8519: AND l.header_id = h.header_id
8520: AND t.payment_type_code =