DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_ORDER_LINES_ALL

Line 6035: FROM oe_order_lines_all l

6031: ( l.ordered_quantity * l.unit_selling_price )
6032: + DECODE(l_include_tax_flag, 'Y',
6033: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
6034: )
6035: FROM oe_order_lines_all l
6036: , oe_order_headers h
6037: , hz_cust_site_uses_all su
6038: , hz_cust_acct_sites_all cas
6039: WHERE h.invoice_to_org_id = su.site_use_id

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

6774: AND oh.hold_release_id IS NULL )
6775: AND EXISTS
6776: (SELECT NULL
6777: FROM oe_payment_types_all pt,
6778: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6779: WHERE pt.credit_check_flag = 'Y'
6780: AND l.header_id = h.header_id
6781: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6782: AND NVL(pt.org_id, -99) = G_ORG_ID

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

6823: AND oh.hold_release_id IS NULL )
6824: AND EXISTS
6825: (SELECT NULL
6826: FROM oe_payment_types_all pt,
6827: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6828: WHERE pt.credit_check_flag = 'Y'
6829: AND l.header_id = h.header_id
6830: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6831: AND NVL(pt.org_id, -99) = G_ORG_ID

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

6871: AND oh.hold_release_id IS NULL )
6872: AND EXISTS
6873: (SELECT NULL
6874: FROM oe_payment_types_all pt,
6875: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6876: WHERE pt.credit_check_flag = 'Y'
6877: AND l.header_id = h.header_id
6878: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6879: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 8022: FROM oe_order_lines_ALL l

8018: ( l.ordered_quantity * l.unit_selling_price )
8019: + DECODE(l_include_tax_flag, 'Y',
8020: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
8021: )
8022: FROM oe_order_lines_ALL l
8023: , oe_order_headers_ALL h
8024: , hz_cust_site_uses_ALL su
8025: , hz_cust_acct_sites_ALL cas
8026: WHERE h.invoice_to_org_id = su.site_use_id

Line 8061: FROM oe_order_lines_ALL l

8057: * l.unit_selling_price )
8058: + DECODE(l_include_tax_flag, 'Y',
8059: NVL(DECODE(l.line_category_code,'RETURN',(-1)*NVL(l.tax_line_value,l.tax_value),NVL(l.tax_line_value,l.tax_value)),0),0) --TaxER
8060: )
8061: FROM oe_order_lines_ALL l
8062: , oe_order_headers_ALL h
8063: , hz_cust_site_uses_ALL su
8064: , hz_cust_acct_sites_ALL cas
8065: WHERE h.invoice_to_org_id = su.site_use_id

Line 8099: , OE_ORDER_LINES_ALL L

8095: (p_curr_code IN VARCHAR2 default NULL) IS
8096: SELECT NVL(SUM(P.commitment_applied_amount), 0)
8097: FROM OE_PAYMENTS P
8098: , OE_ORDER_HEADERS_ALL H
8099: , OE_ORDER_LINES_ALL L
8100: , hz_cust_site_uses_ALL su
8101: , hz_cust_acct_sites_ALL cas
8102: WHERE H.invoice_to_org_id = su.site_use_id
8103: AND cas.cust_acct_site_id = su.cust_acct_site_id

Line 8138: FROM oe_order_lines_ALL l

8134: ( l.ordered_quantity * l.unit_selling_price )
8135: + DECODE(l_include_tax_flag, 'Y',
8136: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
8137: )
8138: FROM oe_order_lines_ALL l
8139: , oe_order_headers_ALL h
8140: , hz_cust_site_uses_ALL su
8141: , hz_cust_acct_sites_ALL cas
8142: WHERE h.invoice_to_org_id = su.site_use_id

Line 8181: FROM oe_order_lines_ALL l

8177: * l.unit_selling_price )
8178: + DECODE(l_include_tax_flag, 'Y',
8179: NVL(DECODE(l.line_category_code,'RETURN',(-1)*NVL(l.tax_line_value,l.tax_value),NVL(l.tax_line_value,l.tax_value)),0),0 ) --TaxER
8180: )
8181: FROM oe_order_lines_ALL l
8182: , oe_order_headers_ALL h
8183: , hz_cust_site_uses_ALL su
8184: , hz_cust_acct_sites_ALL cas
8185: WHERE h.invoice_to_org_id = su.site_use_id

Line 8220: FROM oe_order_lines_ALL l

8216: ( l.ordered_quantity * l.unit_selling_price )
8217: + DECODE(l_include_tax_flag, 'Y',
8218: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
8219: )
8220: FROM oe_order_lines_ALL l
8221: , oe_order_headers_ALL h
8222: , hz_cust_site_uses_ALL su
8223: , hz_cust_acct_sites_ALL cas
8224: WHERE h.invoice_to_org_id = su.site_use_id

Line 8262: FROM oe_order_lines_ALL l

8258: * l.unit_selling_price )
8259: + DECODE(l_include_tax_flag, 'Y',
8260: NVL(DECODE(l.line_category_code,'RETURN',(-1)*NVL(l.tax_line_value,l.tax_value),NVL(l.tax_line_value,l.tax_value)),0),0 ) --TaxER
8261: )
8262: FROM oe_order_lines_ALL l
8263: , oe_order_headers_ALL h
8264: , hz_cust_site_uses_ALL su
8265: , hz_cust_acct_sites_ALL cas
8266: WHERE h.invoice_to_org_id = su.site_use_id

Line 8307: , oe_order_lines_ALL l

8303: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8304: --TaxER End
8305: )
8306: FROM oe_price_adjustments p
8307: , oe_order_lines_ALL l
8308: , oe_order_headers_ALL h
8309: , hz_cust_site_uses_ALL su
8310: , hz_cust_acct_sites_ALL cas
8311: WHERE h.invoice_to_org_id = su.site_use_id

Line 8357: , oe_order_lines_ALL l

8353: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8354: --TaxER End
8355: )
8356: FROM oe_price_adjustments p
8357: , oe_order_lines_ALL l
8358: , oe_order_headers_ALL h
8359: , hz_cust_site_uses_ALL su
8360: , hz_cust_acct_sites_ALL cas
8361: WHERE h.invoice_to_org_id = su.site_use_id

Line 8423: oe_order_lines_all l

8419: AND h.header_id <> l_header_id
8420: AND EXISTS
8421: ( SELECT NULL
8422: FROM oe_payment_types_all t,
8423: oe_order_lines_all l
8424: WHERE t.credit_check_flag = 'Y'
8425: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8426: AND l.header_id = h.header_id
8427: AND t.payment_type_code =

Line 8467: oe_order_lines_all l

8463: AND h.header_id <> l_header_id
8464: AND EXISTS
8465: ( SELECT NULL
8466: FROM oe_payment_types_all t,
8467: oe_order_lines_all l
8468: WHERE t.credit_check_flag = 'Y'
8469: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8470: AND l.header_id = h.header_id
8471: AND t.payment_type_code =

Line 8491: , oe_order_lines_ALL l

8487: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8488: --TaxER End
8489: )
8490: FROM oe_price_adjustments p
8491: , oe_order_lines_ALL l
8492: , oe_order_headers_ALL h
8493: , hz_cust_site_uses_ALL su
8494: , hz_cust_acct_sites_ALL cas
8495: WHERE h.invoice_to_org_id = su.site_use_id

Line 8545: , oe_order_lines_ALL l

8541: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8542: --TaxER End
8543: )
8544: FROM oe_price_adjustments p
8545: , oe_order_lines_ALL l
8546: , oe_order_headers_ALL h
8547: , hz_cust_site_uses_ALL su
8548: , hz_cust_acct_sites_ALL cas
8549: WHERE h.invoice_to_org_id = su.site_use_id

Line 8596: , oe_order_lines_ALL l

8592: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8593: --TaxER End
8594: )
8595: FROM oe_price_adjustments p
8596: , oe_order_lines_ALL l
8597: , oe_order_headers_ALL h
8598: , hz_cust_site_uses_ALL su
8599: , hz_cust_acct_sites_ALL cas
8600: WHERE h.invoice_to_org_id = su.site_use_id

Line 8650: , oe_order_lines_ALL l

8646: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
8647: --TaxER End
8648: )
8649: FROM oe_price_adjustments p
8650: , oe_order_lines_ALL l
8651: , oe_order_headers_ALL h
8652: , hz_cust_site_uses_ALL su
8653: , hz_cust_acct_sites_ALL cas
8654: WHERE h.invoice_to_org_id = su.site_use_id

Line 8725: oe_order_lines_all l

8721: AND oh.hold_release_id IS NULL )
8722: AND EXISTS
8723: ( SELECT NULL
8724: FROM oe_payment_types_all t,
8725: oe_order_lines_all l
8726: WHERE t.credit_check_flag = 'Y'
8727: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8728: AND l.header_id = h.header_id
8729: AND t.payment_type_code =

Line 8774: oe_order_lines_all l

8770: AND oh.hold_release_id IS NULL )
8771: AND EXISTS
8772: ( SELECT NULL
8773: FROM oe_payment_types_all t,
8774: oe_order_lines_all l
8775: WHERE t.credit_check_flag = 'Y'
8776: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8777: AND l.header_id = h.header_id
8778: AND t.payment_type_code =

Line 8821: oe_order_lines_all l

8817: AND oh.hold_release_id IS NULL )
8818: AND EXISTS
8819: ( SELECT NULL
8820: FROM oe_payment_types_all t,
8821: oe_order_lines_all l
8822: WHERE t.credit_check_flag = 'Y'
8823: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8824: AND l.header_id = h.header_id
8825: AND t.payment_type_code =

Line 8869: oe_order_lines_all l

8865: AND oh.hold_release_id IS NULL )
8866: AND EXISTS
8867: ( SELECT NULL
8868: FROM oe_payment_types_all t,
8869: oe_order_lines_all l
8870: WHERE t.credit_check_flag = 'Y'
8871: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8872: AND l.header_id = h.header_id
8873: AND t.payment_type_code =