[Home] [Help]
2415: AND trm.credit_check_flag = 'Y'
2416: AND EXISTS
2417: (SELECT NULL
2418: FROM oe_payment_types_all pt,
2419: oe_order_headers_all h
2420: WHERE pt.credit_check_flag = 'Y'
2421: AND h.header_id = p_header_id
2422: AND ln.header_id = h.header_id
2423: AND NVL(pt.org_id, -99) = G_ORG_ID
3173:
3174:
3175: CURSOR trx_curr_csr_customer_global IS
3176: SELECT soh.transactional_curr_code user_code
3177: FROM oe_order_headers_ALL soh
3178: , hz_cust_acct_sites_ALL cas
3179: , hz_cust_site_uses_ALL su
3180: WHERE soh.invoice_to_org_id = su.site_use_id
3181: AND cas.cust_acct_site_id = su.cust_acct_site_id
4547: + ( l.unit_selling_price * l.ordered_quantity )
4548: )
4549: INTO l_order_value
4550: FROM oe_order_lines l,
4551: oe_order_headers_all h,
4552: ra_terms_b t,
4553: HZ_CUST_SITE_USES_ALL su,
4554: HZ_CUST_ACCT_SITES_ALL cas
4555: WHERE h.header_id = p_header_id
4590: l.ordered_quantity) )
4591: ))
4592: INTO l_order_value
4593: FROM oe_order_lines l,
4594: oe_order_headers_all h,
4595: ra_terms_b t,
4596: HZ_CUST_SITE_USES_ALL su,
4597: HZ_CUST_ACCT_SITES_ALL cas
4598: WHERE h.header_id = p_header_id
4632: END IF;
4633:
4634: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4635: INTO l_commitment
4636: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4637: HZ_CUST_SITE_USES_ALL su,
4638: HZ_CUST_ACCT_SITES_ALL cas,
4639: ra_terms_b t
4640: WHERE h.header_id = p_header_id
4699: --TaxER End
4700: )
4701: INTO l_freights
4702: FROM oe_order_lines l,
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
4759: --TaxER End
4760: )
4761: INTO l_freights
4762: FROM oe_order_lines l,
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
4822: + ( l.unit_selling_price * l.ordered_quantity )
4823: )
4824: INTO l_order_value
4825: FROM oe_order_lines l,
4826: oe_order_headers_all h,
4827: ra_terms_b t
4828: WHERE h.header_id = p_header_id
4829: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4830: AND h.header_id = l.header_id
4860: (-1)*l.ordered_quantity,l.ordered_quantity))
4861: )
4862: INTO l_order_value
4863: FROM oe_order_lines l,
4864: oe_order_headers_all h,
4865: ra_terms_b t
4866: WHERE h.header_id = p_header_id
4867: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4868: AND h.header_id = l.header_id
4893: BEGIN
4894: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4895: INTO l_commitment
4896: FROM OE_PAYMENTS P,
4897: OE_ORDER_HEADERS_ALL H,
4898: OE_ORDER_LINES L,
4899: ra_terms_b t
4900: WHERE h.header_id = p_header_id
4901: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4958: --TaxER End
4959: )
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 */
5015: --TaxER End
5016: )
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 */
5076: + ( l.unit_selling_price * l.ordered_quantity )
5077: )
5078: INTO l_order_value
5079: FROM oe_order_lines l,
5080: oe_order_headers_all h,
5081: ra_terms_b t
5082: WHERE h.header_id = p_header_id
5083: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5084: AND h.header_id = l.header_id
5113: (-1)*l.ordered_quantity,l.ordered_quantity))
5114: )
5115: INTO l_order_value
5116: FROM oe_order_lines l,
5117: oe_order_headers_all h,
5118: ra_terms_b t
5119: WHERE h.header_id = p_header_id
5120: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5121: AND h.header_id = l.header_id
5152:
5153: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5154: INTO l_commitment
5155: FROM oe_order_lines l,
5156: oe_order_headers_all h,
5157: ra_terms_b t,
5158: oe_payments p
5159: WHERE h.header_id = p_header_id
5160: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
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
5243: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5244: AND p.line_id = l.line_id
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
5321: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5322: AND p.line_id = l.line_id
6071: + DECODE(l_include_tax_flag, 'Y',
6072: 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
6073: ))
6074: FROM oe_order_lines l
6075: , oe_order_headers_all h
6076: , hz_cust_site_uses_all su
6077: , hz_cust_acct_sites_all cas
6078: WHERE h.invoice_to_org_id = su.site_use_id
6079: AND h.org_id = su.org_id
6105: ------------------------------------------------
6106:
6107: Cursor customer_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
6108: SELECT NVL(SUM(P.commitment_applied_amount), 0)
6109: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
6110: , hz_cust_site_uses_all su
6111: , hz_cust_acct_sites_all cas
6112: WHERE H.invoice_to_org_id = su.site_use_id
6113: AND h.org_id = su.org_id
6136: OR
6137: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
6138: Cursor site_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
6139: SELECT NVL(SUM(P.commitment_applied_amount), 0)
6140: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
6141: WHERE H.INVOICE_TO_ORG_ID = p_site_use_id
6142: AND H.TRANSACTIONAL_CURR_CODE = p_curr_code
6143: AND H.OPEN_FLAG = 'Y'
6144: AND H.BOOKED_FLAG = 'Y'
6172: + DECODE(l_include_tax_flag, 'Y',
6173: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
6174: )
6175: FROM oe_order_lines l
6176: , oe_order_headers_all h
6177: , hz_cust_site_uses_all su
6178: , hz_cust_acct_sites_all cas
6179: WHERE h.invoice_to_org_id = su.site_use_id
6180: AND h.org_id = su.org_id
6215: + DECODE(l_include_tax_flag, 'Y',
6216: 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
6217: )
6218: FROM oe_order_lines l
6219: , oe_order_headers_all h
6220: , hz_cust_site_uses_all su
6221: , hz_cust_acct_sites_all cas
6222: WHERE h.invoice_to_org_id = su.site_use_id
6223: AND h.org_id = su.org_id
6254: + DECODE(l_include_tax_flag, 'Y',
6255: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
6256: )
6257: FROM oe_order_lines l
6258: , oe_order_headers_all h
6259: , hz_cust_site_uses_all su
6260: , hz_cust_acct_sites_all cas
6261: WHERE h.invoice_to_org_id = su.site_use_id
6262: AND h.org_id = su.org_id
6297: + DECODE(l_include_tax_flag, 'Y',
6298: 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
6299: )
6300: FROM oe_order_lines l
6301: , oe_order_headers_all h
6302: , hz_cust_site_uses_all su
6303: , hz_cust_acct_sites_all cas
6304: WHERE h.invoice_to_org_id = su.site_use_id
6305: AND h.org_id = su.org_id
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
6352: WHERE h.invoice_to_org_id = su.site_use_id
6353: AND h.org_id = su.org_id
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
6402: WHERE h.invoice_to_org_id = su.site_use_id
6403: AND h.org_id = su.org_id
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
6496: AND h.org_id = su.org_id /* MOAC_SQL_CHANGE */
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
6543: WHERE h.invoice_to_org_id = su.site_use_id
6544: AND h.org_id = su.org_id
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
6597: WHERE h.invoice_to_org_id = su.site_use_id
6598: AND h.org_id = su.org_id
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
6650: WHERE h.invoice_to_org_id = su.site_use_id
6651: AND h.org_id = su.org_id
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
6705: WHERE h.invoice_to_org_id = su.site_use_id
6706: AND h.org_id = su.org_id
7044: + DECODE(l_include_tax_flag, 'Y',
7045: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 ) --TaxER
7046: )
7047: FROM oe_order_lines l
7048: , oe_order_headers_all h
7049: WHERE h.invoice_to_org_id = p_site_use_id
7050: AND h.header_id = l.header_id
7051: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7052: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7080: + DECODE(l_include_tax_flag, 'Y',
7081: 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
7082: )
7083: FROM oe_order_lines l
7084: , oe_order_headers_all h
7085: WHERE h.invoice_to_org_id = p_site_use_id
7086: AND h.header_id = l.header_id
7087: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7088: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7112: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 --TaxER
7113: )
7114: )
7115: FROM oe_order_lines l
7116: , oe_order_headers_all h
7117: WHERE h.invoice_to_org_id = p_site_use_id
7118: AND h.header_id = l.header_id
7119: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7120: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7152: + DECODE(l_include_tax_flag, 'Y',
7153: 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
7154: )
7155: FROM oe_order_lines l
7156: , oe_order_headers_all h
7157: WHERE h.invoice_to_org_id = p_site_use_id
7158: AND h.header_id = l.header_id
7159: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7160: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7186: NVL(NVL(l.tax_line_value,l.tax_value),0), 0 --TaxER
7187: )
7188: )
7189: FROM oe_order_lines l
7190: , oe_order_headers_all h
7191: WHERE h.invoice_to_org_id = p_site_use_id
7192: AND h.header_id = l.header_id
7193: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7194: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7223: + DECODE(l_include_tax_flag, 'Y',
7224: 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
7225: )
7226: FROM oe_order_lines l
7227: , oe_order_headers_all h
7228: WHERE h.invoice_to_org_id = p_site_use_id
7229: AND h.header_id = l.header_id
7230: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
7231: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
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
7269: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7270: <= l_shipping_horizon
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
7315: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7316: <= l_shipping_horizon
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
7434: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7435: <= l_shipping_horizon
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
7484: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7485: <= l_shipping_horizon
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
7531: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7532: <= l_shipping_horizon
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
7580: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7581: <= l_shipping_horizon
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
8027: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8066: AND cas.cust_acct_site_id = su.cust_acct_site_id
8094: Cursor cust_commitment_total_global
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
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
8143: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8186: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8225: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8267: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8312: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8362: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8406: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8450: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8496: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8550: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8601: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8655: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8703: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8752: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8799: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8847: AND cas.cust_acct_site_id = su.cust_acct_site_id