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_PRICE_ADJUSTMENTS

Line 4545: oe_price_adjustments p

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
4547: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4548: AND h.header_id = l.header_id
4549: AND p.line_id = l.line_id

Line 4600: oe_price_adjustments p

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
4602: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4603: AND h.header_id = l.header_id
4604: AND p.line_id = l.line_id

Line 4789: oe_price_adjustments p

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
4793: AND p.line_id = l.line_id

Line 4841: oe_price_adjustments p

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
4845: AND p.line_id = l.line_id

Line 5050: FROM oe_price_adjustments p

5046: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
5047: p.operand, (l.ordered_quantity * p.adjusted_amount))
5048: )
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

Line 5083: oe_price_adjustments p

5079: SELECT
5080: SUM(DECODE(P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
5081: INTO l_freights_hdr_2
5082: FROM
5083: oe_price_adjustments p
5084: , oe_order_headers h
5085: WHERE h.header_id = p_header_id
5086: AND p.line_id IS NULL
5087: AND p.header_id = h.header_id

Line 5119: FROM oe_price_adjustments p

5115: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
5116: p.operand, (l.ordered_quantity * p.adjusted_amount))
5117: )
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

Line 5153: oe_price_adjustments p

5149: SELECT
5150: SUM(DECODE(P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
5151: INTO l_freights_hdr_2
5152: FROM
5153: oe_price_adjustments p
5154: , oe_order_headers h
5155: WHERE h.header_id = p_header_id
5156: AND p.line_id IS NULL
5157: AND p.header_id = h.header_id

Line 6136: FROM oe_price_adjustments p

6132: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6133: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6134: p.operand, (l.ordered_quantity * p.adjusted_amount))
6135: )
6136: FROM oe_price_adjustments p
6137: , oe_order_lines l
6138: , oe_order_headers_all h
6139: , hz_cust_site_uses_all su
6140: , hz_cust_acct_sites_all cas

Line 6182: FROM oe_price_adjustments p

6178: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6179: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6180: p.operand, (l.ordered_quantity * p.adjusted_amount))
6181: )
6182: FROM oe_price_adjustments p
6183: , oe_order_lines l
6184: , oe_order_headers_all h
6185: , hz_cust_site_uses_all su
6186: , hz_cust_acct_sites_all cas

Line 6225: oe_price_adjustments p

6221: CURSOR cust_uninv_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
6222: SELECT
6223: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6224: FROM
6225: oe_price_adjustments p
6226: , oe_order_headers h
6227: , hz_cust_site_uses_all su
6228: , hz_cust_acct_sites_all cas
6229: WHERE h.invoice_to_org_id = su.site_use_id

Line 6268: oe_price_adjustments p

6264: CURSOR cust_uninv_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
6265: SELECT
6266: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6267: FROM
6268: oe_price_adjustments p
6269: , oe_order_headers_all h
6270: , hz_cust_site_uses_all su
6271: , hz_cust_acct_sites_all cas
6272: WHERE h.invoice_to_org_id = su.site_use_id

Line 6311: FROM oe_price_adjustments p

6307: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6308: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6309: p.operand, (l.ordered_quantity * p.adjusted_amount))
6310: )
6311: FROM oe_price_adjustments p
6312: , oe_order_lines l
6313: , oe_order_headers_all h
6314: , hz_cust_site_uses_all su
6315: , hz_cust_acct_sites_all cas

Line 6361: FROM oe_price_adjustments p

6357: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6358: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6359: p.operand, (l.ordered_quantity * p.adjusted_amount))
6360: )
6361: FROM oe_price_adjustments p
6362: , oe_order_lines l
6363: , oe_order_headers_all h
6364: , hz_cust_site_uses_all su
6365: , hz_cust_acct_sites_all cas

Line 6410: FROM oe_price_adjustments p

6406: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6407: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6408: p.operand, (l.ordered_quantity * p.adjusted_amount))
6409: )
6410: FROM oe_price_adjustments p
6411: , oe_order_lines l
6412: , oe_order_headers_all h
6413: , hz_cust_site_uses_all su
6414: , hz_cust_acct_sites_all cas

Line 6461: FROM oe_price_adjustments p

6457: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
6458: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
6459: p.operand, (l.ordered_quantity * p.adjusted_amount))
6460: )
6461: FROM oe_price_adjustments p
6462: , oe_order_lines l
6463: , oe_order_headers_all h
6464: , hz_cust_site_uses_all su
6465: , hz_cust_acct_sites_all cas

Line 6507: oe_price_adjustments p

6503: CURSOR cust_no_hold_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
6504: SELECT
6505: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6506: FROM
6507: oe_price_adjustments p
6508: , oe_order_headers h
6509: , hz_cust_site_uses_all su
6510: , hz_cust_acct_sites_all cas
6511: WHERE h.invoice_to_org_id = su.site_use_id

Line 6552: oe_price_adjustments p

6548: CURSOR cust_no_hold_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
6549: SELECT
6550: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6551: FROM
6552: oe_price_adjustments p
6553: , oe_order_headers h
6554: , hz_cust_site_uses_all su
6555: , hz_cust_acct_sites_all cas
6556: WHERE h.invoice_to_org_id = su.site_use_id

Line 6596: oe_price_adjustments p

6592: CURSOR cust_hold_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
6593: SELECT
6594: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6595: FROM
6596: oe_price_adjustments p
6597: , oe_order_headers h
6598: , hz_cust_site_uses_all su
6599: , hz_cust_acct_sites_all cas
6600: WHERE h.invoice_to_org_id = su.site_use_id

Line 6641: oe_price_adjustments p

6637: CURSOR cust_hold_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
6638: SELECT
6639: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
6640: FROM
6641: oe_price_adjustments p
6642: , oe_order_headers h
6643: , hz_cust_site_uses_all su
6644: , hz_cust_acct_sites_all cas
6645: WHERE h.invoice_to_org_id = su.site_use_id

Line 7005: FROM oe_price_adjustments p

7001: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7002: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7003: p.operand, (l.ordered_quantity * p.adjusted_amount))
7004: )
7005: FROM oe_price_adjustments p
7006: , oe_order_lines l
7007: , oe_order_headers_all h
7008: WHERE h.invoice_to_org_id = p_site_use_id
7009: AND p.line_id = l.line_id

Line 7047: FROM oe_price_adjustments p

7043: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7044: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7045: p.operand, (l.ordered_quantity * p.adjusted_amount))
7046: )
7047: FROM oe_price_adjustments p
7048: , oe_order_lines l
7049: , oe_order_headers_all h
7050: WHERE h.invoice_to_org_id = p_site_use_id
7051: AND p.line_id = l.line_id

Line 7082: oe_price_adjustments p

7078: CURSOR site_uninv_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
7079: SELECT
7080: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7081: FROM
7082: oe_price_adjustments p
7083: , oe_order_headers h
7084: WHERE h.invoice_to_org_id = p_site_use_id
7085: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7086: AND h.transactional_curr_code = p_curr_code

Line 7117: oe_price_adjustments p

7113: CURSOR site_uninv_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
7114: SELECT
7115: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7116: FROM
7117: oe_price_adjustments p
7118: , oe_order_headers h
7119: WHERE h.invoice_to_org_id = p_site_use_id
7120: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7121: AND h.transactional_curr_code = p_curr_code

Line 7154: FROM oe_price_adjustments p

7150: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7151: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7152: p.operand, (l.ordered_quantity * p.adjusted_amount))
7153: )
7154: FROM oe_price_adjustments p
7155: , oe_order_lines l
7156: , oe_order_headers_all h
7157: WHERE h.invoice_to_org_id = p_site_use_id
7158: AND p.line_id = l.line_id

Line 7200: FROM oe_price_adjustments p

7196: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7197: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7198: p.operand, (l.ordered_quantity * p.adjusted_amount))
7199: )
7200: FROM oe_price_adjustments p
7201: , oe_order_lines l
7202: , oe_order_headers_all h
7203: WHERE h.invoice_to_org_id = p_site_use_id
7204: AND p.line_id = l.line_id

Line 7243: FROM oe_price_adjustments p

7239: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7240: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7241: p.operand, (l.ordered_quantity * p.adjusted_amount))
7242: )
7243: FROM oe_price_adjustments p
7244: , oe_order_lines l
7245: , oe_order_headers_all h
7246: WHERE h.invoice_to_org_id = p_site_use_id
7247: AND p.line_id = l.line_id

Line 7288: FROM oe_price_adjustments p

7284: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
7285: * DECODE( p.arithmetic_operator, 'LUMPSUM', --bug 4295299
7286: p.operand, (l.ordered_quantity * p.adjusted_amount))
7287: )
7288: FROM oe_price_adjustments p
7289: , oe_order_lines l
7290: , oe_order_headers_all h
7291: WHERE h.invoice_to_org_id = p_site_use_id
7292: AND p.line_id = l.line_id

Line 7334: oe_price_adjustments p

7330: CURSOR site_no_hold_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
7331: SELECT
7332: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7333: FROM
7334: oe_price_adjustments p
7335: , oe_order_headers h
7336: WHERE h.invoice_to_org_id = p_site_use_id
7337: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7338: AND h.transactional_curr_code = p_curr_code

Line 7375: oe_price_adjustments p

7371: CURSOR site_no_hold_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
7372: SELECT
7373: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7374: FROM
7375: oe_price_adjustments p
7376: , oe_order_headers h
7377: WHERE h.invoice_to_org_id = p_site_use_id
7378: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7379: AND h.transactional_curr_code = p_curr_code

Line 7415: oe_price_adjustments p

7411: CURSOR site_hold_hdr_freight2 (p_curr_code IN VARCHAR2 default null) IS
7412: SELECT
7413: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7414: FROM
7415: oe_price_adjustments p
7416: , oe_order_headers h
7417: WHERE h.invoice_to_org_id = p_site_use_id
7418: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7419: AND h.transactional_curr_code = p_curr_code

Line 7455: oe_price_adjustments p

7451: CURSOR site_hold_hdr_freight2_ret (p_curr_code IN VARCHAR2 default null) IS
7452: SELECT
7453: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
7454: FROM
7455: oe_price_adjustments p
7456: , oe_order_headers h
7457: WHERE h.invoice_to_org_id = p_site_use_id
7458: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7459: AND h.transactional_curr_code = p_curr_code

Line 7988: --- There is not multi org table for oe_price_adjustments

7984: OR
7985: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
7986:
7987: -- customer hdr freights , Does not include curr order
7988: --- There is not multi org table for oe_price_adjustments
7989:
7990: CURSOR cust_uninv_hdr_freight1_global
7991: (p_curr_code IN VARCHAR2 default null) IS
7992: SELECT

Line 7998: FROM oe_price_adjustments p

7994: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8034: --- There is not multi org table for oe_price_adjustments

8030: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
8031:
8032:
8033: -- customer hdr freights including Returns, Does not include curr order
8034: --- There is not multi org table for oe_price_adjustments
8035:
8036: CURSOR cust_uninv_hdr_fr1_glb_ret
8037: (p_curr_code IN VARCHAR2 default null) IS
8038: SELECT

Line 8044: FROM oe_price_adjustments p

8040: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8085: oe_price_adjustments p

8081: (p_curr_code IN VARCHAR2 default null) IS
8082: SELECT
8083: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8084: FROM
8085: oe_price_adjustments p
8086: , oe_order_headers_ALL h
8087: , hz_cust_site_uses_ALL su
8088: , hz_cust_acct_sites_ALL cas
8089: WHERE h.invoice_to_org_id = su.site_use_id

Line 8125: oe_price_adjustments p

8121: (p_curr_code IN VARCHAR2 default null) IS
8122: SELECT
8123: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8124: FROM
8125: oe_price_adjustments p
8126: , oe_order_headers_ALL h
8127: , hz_cust_site_uses_ALL su
8128: , hz_cust_acct_sites_ALL cas
8129: WHERE h.invoice_to_org_id = su.site_use_id

Line 8166: FROM oe_price_adjustments p

8162: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8216: FROM oe_price_adjustments p

8212: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8263: FROM oe_price_adjustments p

8259: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8313: FROM oe_price_adjustments p

8309: ( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) )
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

Line 8358: oe_price_adjustments p

8354: (p_curr_code IN VARCHAR2 default null) IS
8355: SELECT
8356: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8357: FROM
8358: oe_price_adjustments p
8359: , oe_order_headers_ALL h
8360: , hz_cust_site_uses_ALL su
8361: , hz_cust_acct_sites_ALL cas
8362: WHERE h.invoice_to_org_id = su.site_use_id

Line 8403: oe_price_adjustments p

8399: (p_curr_code IN VARCHAR2 default null) IS
8400: SELECT
8401: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8402: FROM
8403: oe_price_adjustments p
8404: , oe_order_headers_ALL h
8405: , hz_cust_site_uses_ALL su
8406: , hz_cust_acct_sites_ALL cas
8407: WHERE h.invoice_to_org_id = su.site_use_id

Line 8446: oe_price_adjustments p

8442: (p_curr_code IN VARCHAR2 default null) IS
8443: SELECT
8444: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8445: FROM
8446: oe_price_adjustments p
8447: , oe_order_headers_ALL h
8448: , hz_cust_site_uses_ALL su
8449: , hz_cust_acct_sites_ALL cas
8450: WHERE h.invoice_to_org_id = su.site_use_id

Line 8490: oe_price_adjustments p

8486: (p_curr_code IN VARCHAR2 default null) IS
8487: SELECT
8488: SUM( DECODE( P.CREDIT_OR_CHARGE_FLAG, 'C', (-1), (+1) ) * P.OPERAND )
8489: FROM
8490: oe_price_adjustments p
8491: , oe_order_headers_ALL h
8492: , hz_cust_site_uses_ALL su
8493: , hz_cust_acct_sites_ALL cas
8494: WHERE h.invoice_to_org_id = su.site_use_id