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 4707: oe_price_adjustments p

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
4709: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4710: AND h.header_id = l.header_id
4711: AND p.line_id = l.line_id

Line 4767: oe_price_adjustments p

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
4769: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4770: AND h.header_id = l.header_id
4771: AND p.line_id = l.line_id

Line 4964: oe_price_adjustments p

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

Line 5021: oe_price_adjustments p

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

Line 5238: FROM oe_price_adjustments p

5234: + DECODE(p_credit_check_rule_rec.include_tax_flag ,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
5235: --TaxER End
5236: )
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

Line 5276: oe_price_adjustments p

5272: + DECODE(p_credit_check_rule_rec.include_tax_flag ,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
5273: --TaxER End
5274: INTO l_freights_hdr_2
5275: FROM
5276: oe_price_adjustments p
5277: , oe_order_headers h
5278: WHERE h.header_id = p_header_id
5279: AND p.line_id IS NULL
5280: AND p.header_id = h.header_id

Line 5316: FROM oe_price_adjustments p

5312: + DECODE(p_credit_check_rule_rec.include_tax_flag ,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
5313: --TaxER End
5314: )
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

Line 5355: oe_price_adjustments p

5351: + DECODE(p_credit_check_rule_rec.include_tax_flag ,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
5352: --TaxER End
5353: INTO l_freights_hdr_2
5354: FROM
5355: oe_price_adjustments p
5356: , oe_order_headers h
5357: WHERE h.header_id = p_header_id
5358: AND p.line_id IS NULL
5359: AND p.header_id = h.header_id

Line 6347: FROM oe_price_adjustments p

6343: --TaxER Start
6344: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6345: --TaxER End
6346: )
6347: FROM oe_price_adjustments p
6348: , oe_order_lines l
6349: , oe_order_headers_all h
6350: , hz_cust_site_uses_all su
6351: , hz_cust_acct_sites_all cas

Line 6397: FROM oe_price_adjustments p

6393: --TaxER Start
6394: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6395: --TaxER End
6396: )
6397: FROM oe_price_adjustments p
6398: , oe_order_lines l
6399: , oe_order_headers_all h
6400: , hz_cust_site_uses_all su
6401: , hz_cust_acct_sites_all cas

Line 6444: oe_price_adjustments p

6440: --TaxER Start
6441: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6442: --TaxER End
6443: FROM
6444: oe_price_adjustments p
6445: , oe_order_headers h
6446: , hz_cust_site_uses_all su
6447: , hz_cust_acct_sites_all cas
6448: WHERE h.invoice_to_org_id = su.site_use_id

Line 6491: oe_price_adjustments p

6487: --TaxER Start
6488: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6489: --TaxER End
6490: FROM
6491: oe_price_adjustments p
6492: , oe_order_headers_all h
6493: , hz_cust_site_uses_all su
6494: , hz_cust_acct_sites_all cas
6495: WHERE h.invoice_to_org_id = su.site_use_id

Line 6538: FROM oe_price_adjustments p

6534: --TaxER Start
6535: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6536: --TaxER End
6537: )
6538: FROM oe_price_adjustments p
6539: , oe_order_lines l
6540: , oe_order_headers_all h
6541: , hz_cust_site_uses_all su
6542: , hz_cust_acct_sites_all cas

Line 6592: FROM oe_price_adjustments p

6588: --TaxER Start
6589: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6590: --TaxER End
6591: )
6592: FROM oe_price_adjustments p
6593: , oe_order_lines l
6594: , oe_order_headers_all h
6595: , hz_cust_site_uses_all su
6596: , hz_cust_acct_sites_all cas

Line 6645: FROM oe_price_adjustments p

6641: --TaxER Start
6642: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6643: --TaxER End
6644: )
6645: FROM oe_price_adjustments p
6646: , oe_order_lines l
6647: , oe_order_headers_all h
6648: , hz_cust_site_uses_all su
6649: , hz_cust_acct_sites_all cas

Line 6700: FROM oe_price_adjustments p

6696: --TaxER Start
6697: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
6698: --TaxER End
6699: )
6700: FROM oe_price_adjustments p
6701: , oe_order_lines l
6702: , oe_order_headers_all h
6703: , hz_cust_site_uses_all su
6704: , hz_cust_acct_sites_all cas

Line 6750: oe_price_adjustments p

6746: --TaxER Start
6747: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6748: --TaxER End
6749: FROM
6750: oe_price_adjustments p
6751: , oe_order_headers h
6752: , hz_cust_site_uses_all su
6753: , hz_cust_acct_sites_all cas
6754: WHERE h.invoice_to_org_id = su.site_use_id

Line 6799: oe_price_adjustments p

6795: --TaxER Start
6796: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6797: --TaxER End
6798: FROM
6799: oe_price_adjustments p
6800: , oe_order_headers h
6801: , hz_cust_site_uses_all su
6802: , hz_cust_acct_sites_all cas
6803: WHERE h.invoice_to_org_id = su.site_use_id

Line 6847: oe_price_adjustments p

6843: --TaxER Start
6844: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6845: --TaxER End
6846: FROM
6847: oe_price_adjustments p
6848: , oe_order_headers h
6849: , hz_cust_site_uses_all su
6850: , hz_cust_acct_sites_all cas
6851: WHERE h.invoice_to_org_id = su.site_use_id

Line 6896: oe_price_adjustments p

6892: --TaxER Start
6893: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
6894: --TaxER End
6895: FROM
6896: oe_price_adjustments p
6897: , oe_order_headers h
6898: , hz_cust_site_uses_all su
6899: , hz_cust_acct_sites_all cas
6900: WHERE h.invoice_to_org_id = su.site_use_id

Line 7264: FROM oe_price_adjustments p

7260: --TaxER Start
7261: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7262: --TaxER End
7263: )
7264: FROM oe_price_adjustments p
7265: , oe_order_lines l
7266: , oe_order_headers_all h
7267: WHERE h.invoice_to_org_id = p_site_use_id
7268: AND p.line_id = l.line_id

Line 7310: FROM oe_price_adjustments p

7306: --TaxER Start
7307: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7308: --TaxER End
7309: )
7310: FROM oe_price_adjustments p
7311: , oe_order_lines l
7312: , oe_order_headers_all h
7313: WHERE h.invoice_to_org_id = p_site_use_id
7314: AND p.line_id = l.line_id

Line 7349: oe_price_adjustments p

7345: --TaxER Start
7346: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7347: --TaxER End
7348: FROM
7349: oe_price_adjustments p
7350: , oe_order_headers h
7351: WHERE h.invoice_to_org_id = p_site_use_id
7352: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7353: AND h.transactional_curr_code = p_curr_code

Line 7388: oe_price_adjustments p

7384: --TaxER Start
7385: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7386: --TaxER End
7387: FROM
7388: oe_price_adjustments p
7389: , oe_order_headers h
7390: WHERE h.invoice_to_org_id = p_site_use_id
7391: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7392: AND h.transactional_curr_code = p_curr_code

Line 7429: FROM oe_price_adjustments p

7425: --TaxER Start
7426: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7427: --TaxER End
7428: )
7429: FROM oe_price_adjustments p
7430: , oe_order_lines l
7431: , oe_order_headers_all h
7432: WHERE h.invoice_to_org_id = p_site_use_id
7433: AND p.line_id = l.line_id

Line 7479: FROM oe_price_adjustments p

7475: --TaxER Start
7476: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7477: --TaxER End
7478: )
7479: FROM oe_price_adjustments p
7480: , oe_order_lines l
7481: , oe_order_headers_all h
7482: WHERE h.invoice_to_org_id = p_site_use_id
7483: AND p.line_id = l.line_id

Line 7526: FROM oe_price_adjustments p

7522: --TaxER Start
7523: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7524: --TaxER End
7525: )
7526: FROM oe_price_adjustments p
7527: , oe_order_lines l
7528: , oe_order_headers_all h
7529: WHERE h.invoice_to_org_id = p_site_use_id
7530: AND p.line_id = l.line_id

Line 7575: FROM oe_price_adjustments p

7571: --TaxER Start
7572: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0)
7573: --TaxER End
7574: )
7575: FROM oe_price_adjustments p
7576: , oe_order_lines l
7577: , oe_order_headers_all h
7578: WHERE h.invoice_to_org_id = p_site_use_id
7579: AND p.line_id = l.line_id

Line 7625: oe_price_adjustments p

7621: --TaxER Start
7622: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7623: --TaxER End
7624: FROM
7625: oe_price_adjustments p
7626: , oe_order_headers h
7627: WHERE h.invoice_to_org_id = p_site_use_id
7628: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7629: AND h.transactional_curr_code = p_curr_code

Line 7670: oe_price_adjustments p

7666: --TaxER Start
7667: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7668: --TaxER End
7669: FROM
7670: oe_price_adjustments p
7671: , oe_order_headers h
7672: WHERE h.invoice_to_org_id = p_site_use_id
7673: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7674: AND h.transactional_curr_code = p_curr_code

Line 7714: oe_price_adjustments p

7710: --TaxER Start
7711: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7712: --TaxER End
7713: FROM
7714: oe_price_adjustments p
7715: , oe_order_headers h
7716: WHERE h.invoice_to_org_id = p_site_use_id
7717: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7718: AND h.transactional_curr_code = p_curr_code

Line 7758: oe_price_adjustments p

7754: --TaxER Start
7755: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
7756: --TaxER End
7757: FROM
7758: oe_price_adjustments p
7759: , oe_order_headers h
7760: WHERE h.invoice_to_org_id = p_site_use_id
7761: AND NVL(h.request_date, h.creation_date) <= l_shipping_horizon
7762: AND h.transactional_curr_code = p_curr_code

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

8289: OR
8290: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
8291:
8292: -- customer hdr freights , Does not include curr order
8293: --- There is not multi org table for oe_price_adjustments
8294:
8295: CURSOR cust_uninv_hdr_freight1_global
8296: (p_curr_code IN VARCHAR2 default null) IS
8297: SELECT

Line 8306: FROM oe_price_adjustments p

8302: --TaxER Start
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

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

8339: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
8340:
8341:
8342: -- customer hdr freights including Returns, Does not include curr order
8343: --- There is not multi org table for oe_price_adjustments
8344:
8345: CURSOR cust_uninv_hdr_fr1_glb_ret
8346: (p_curr_code IN VARCHAR2 default null) IS
8347: SELECT

Line 8356: FROM oe_price_adjustments p

8352: --TaxER Start
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

Line 8401: oe_price_adjustments p

8397: --TaxER Start
8398: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8399: --TaxER End
8400: FROM
8401: oe_price_adjustments p
8402: , oe_order_headers_ALL h
8403: , hz_cust_site_uses_ALL su
8404: , hz_cust_acct_sites_ALL cas
8405: WHERE h.invoice_to_org_id = su.site_use_id

Line 8445: oe_price_adjustments p

8441: --TaxER Start
8442: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8443: --TaxER End
8444: FROM
8445: oe_price_adjustments p
8446: , oe_order_headers_ALL h
8447: , hz_cust_site_uses_ALL su
8448: , hz_cust_acct_sites_ALL cas
8449: WHERE h.invoice_to_org_id = su.site_use_id

Line 8490: FROM oe_price_adjustments p

8486: --TaxER Start
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

Line 8544: FROM oe_price_adjustments p

8540: --TaxER Start
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

Line 8595: FROM oe_price_adjustments p

8591: --TaxER Start
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

Line 8649: FROM oe_price_adjustments p

8645: --TaxER Start
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

Line 8698: oe_price_adjustments p

8694: --TaxER Start
8695: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8696: --TaxER End
8697: FROM
8698: oe_price_adjustments p
8699: , oe_order_headers_ALL h
8700: , hz_cust_site_uses_ALL su
8701: , hz_cust_acct_sites_ALL cas
8702: WHERE h.invoice_to_org_id = su.site_use_id

Line 8747: oe_price_adjustments p

8743: --TaxER Start
8744: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8745: --TaxER End
8746: FROM
8747: oe_price_adjustments p
8748: , oe_order_headers_ALL h
8749: , hz_cust_site_uses_ALL su
8750: , hz_cust_acct_sites_ALL cas
8751: WHERE h.invoice_to_org_id = su.site_use_id

Line 8794: oe_price_adjustments p

8790: --TaxER Start
8791: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8792: --TaxER End
8793: FROM
8794: oe_price_adjustments p
8795: , oe_order_headers_ALL h
8796: , hz_cust_site_uses_ALL su
8797: , hz_cust_acct_sites_ALL cas
8798: WHERE h.invoice_to_org_id = su.site_use_id

Line 8842: oe_price_adjustments p

8838: --TaxER Start
8839: + DECODE(l_include_tax_flag,'Y',DECODE(p.list_line_type_code,'TAX',p.adjusted_amount,0),0))
8840: --TaxER End
8841: FROM
8842: oe_price_adjustments p
8843: , oe_order_headers_ALL h
8844: , hz_cust_site_uses_ALL su
8845: , hz_cust_acct_sites_ALL cas
8846: WHERE h.invoice_to_org_id = su.site_use_id