[Home] [Help]
2414: AND trm.credit_check_flag = 'Y'
2415: AND EXISTS
2416: (SELECT NULL
2417: FROM oe_payment_types_all pt,
2418: oe_order_headers_all h
2419: WHERE pt.credit_check_flag = 'Y'
2420: AND h.header_id = p_header_id
2421: AND ln.header_id = h.header_id
2422: AND NVL(pt.org_id, -99) = G_ORG_ID
3172:
3173:
3174: CURSOR trx_curr_csr_customer_global IS
3175: SELECT soh.transactional_curr_code user_code
3176: FROM oe_order_headers_ALL soh
3177: , hz_cust_acct_sites_ALL cas
3178: , hz_cust_site_uses_ALL su
3179: WHERE soh.invoice_to_org_id = su.site_use_id
3180: AND cas.cust_acct_site_id = su.cust_acct_site_id
4391: + ( l.unit_selling_price * l.ordered_quantity )
4392: )
4393: INTO l_order_value
4394: FROM oe_order_lines l,
4395: oe_order_headers_all h,
4396: ra_terms_b t,
4397: HZ_CUST_SITE_USES_ALL su,
4398: HZ_CUST_ACCT_SITES_ALL cas
4399: WHERE h.header_id = p_header_id
4433: l.ordered_quantity) )
4434: ))
4435: INTO l_order_value
4436: FROM oe_order_lines l,
4437: oe_order_headers_all h,
4438: ra_terms_b t,
4439: HZ_CUST_SITE_USES_ALL su,
4440: HZ_CUST_ACCT_SITES_ALL cas
4441: WHERE h.header_id = p_header_id
4474: END IF;
4475:
4476: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4477: INTO l_commitment
4478: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4479: HZ_CUST_SITE_USES_ALL su,
4480: HZ_CUST_ACCT_SITES_ALL cas,
4481: ra_terms_b t
4482: WHERE h.header_id = p_header_id
4537: p.operand, (l.ordered_quantity * p.adjusted_amount))
4538: )
4539: INTO l_freights
4540: FROM oe_order_lines l,
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
4592: p.operand, (l.ordered_quantity * p.adjusted_amount))
4593: )
4594: INTO l_freights
4595: FROM oe_order_lines l,
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
4653: + ( l.unit_selling_price * l.ordered_quantity )
4654: )
4655: INTO l_order_value
4656: FROM oe_order_lines l,
4657: oe_order_headers_all h,
4658: ra_terms_b t
4659: WHERE h.header_id = p_header_id
4660: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4661: AND h.header_id = l.header_id
4690: (-1)*l.ordered_quantity,l.ordered_quantity))
4691: )
4692: INTO l_order_value
4693: FROM oe_order_lines l,
4694: oe_order_headers_all h,
4695: ra_terms_b t
4696: WHERE h.header_id = p_header_id
4697: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4698: AND h.header_id = l.header_id
4722: BEGIN
4723: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4724: INTO l_commitment
4725: FROM OE_PAYMENTS P,
4726: OE_ORDER_HEADERS_ALL H,
4727: OE_ORDER_LINES L,
4728: ra_terms_b t
4729: WHERE h.header_id = p_header_id
4730: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4783: p.operand, (l.ordered_quantity * p.adjusted_amount))
4784: )
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 */
4835: p.operand, (l.ordered_quantity * p.adjusted_amount))
4836: )
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 */
4894: + ( l.unit_selling_price * l.ordered_quantity )
4895: )
4896: INTO l_order_value
4897: FROM oe_order_lines l,
4898: oe_order_headers_all h,
4899: ra_terms_b t
4900: WHERE h.header_id = p_header_id
4901: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4902: AND h.header_id = l.header_id
4930: (-1)*l.ordered_quantity,l.ordered_quantity))
4931: )
4932: INTO l_order_value
4933: FROM oe_order_lines l,
4934: oe_order_headers_all h,
4935: ra_terms_b t
4936: WHERE h.header_id = p_header_id
4937: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4938: AND h.header_id = l.header_id
4968:
4969: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4970: INTO l_commitment
4971: FROM oe_order_lines l,
4972: oe_order_headers_all h,
4973: ra_terms_b t,
4974: oe_payments p
4975: WHERE h.header_id = p_header_id
4976: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
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
5055: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5056: AND p.line_id = l.line_id
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
5124: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5125: AND p.line_id = l.line_id
5863: + DECODE(l_include_tax_flag, 'Y',
5864: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0
5865: ))
5866: FROM oe_order_lines l
5867: , oe_order_headers_all h
5868: , hz_cust_site_uses_all su
5869: , hz_cust_acct_sites_all cas
5870: WHERE h.invoice_to_org_id = su.site_use_id
5871: AND h.org_id = su.org_id
5897: ------------------------------------------------
5898:
5899: Cursor customer_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
5900: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5901: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
5902: , hz_cust_site_uses_all su
5903: , hz_cust_acct_sites_all cas
5904: WHERE H.invoice_to_org_id = su.site_use_id
5905: AND h.org_id = su.org_id
5928: OR
5929: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
5930: Cursor site_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
5931: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5932: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
5933: WHERE H.INVOICE_TO_ORG_ID = p_site_use_id
5934: AND H.TRANSACTIONAL_CURR_CODE = p_curr_code
5935: AND H.OPEN_FLAG = 'Y'
5936: AND H.BOOKED_FLAG = 'Y'
5964: + DECODE(l_include_tax_flag, 'Y',
5965: NVL(l.tax_value,0), 0 )
5966: )
5967: FROM oe_order_lines l
5968: , oe_order_headers_all h
5969: , hz_cust_site_uses_all su
5970: , hz_cust_acct_sites_all cas
5971: WHERE h.invoice_to_org_id = su.site_use_id
5972: AND h.org_id = su.org_id
6007: + DECODE(l_include_tax_flag, 'Y',
6008: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
6009: )
6010: FROM oe_order_lines l
6011: , oe_order_headers_all h
6012: , hz_cust_site_uses_all su
6013: , hz_cust_acct_sites_all cas
6014: WHERE h.invoice_to_org_id = su.site_use_id
6015: AND h.org_id = su.org_id
6046: + DECODE(l_include_tax_flag, 'Y',
6047: NVL(l.tax_value,0), 0 )
6048: )
6049: FROM oe_order_lines l
6050: , oe_order_headers_all h
6051: , hz_cust_site_uses_all su
6052: , hz_cust_acct_sites_all cas
6053: WHERE h.invoice_to_org_id = su.site_use_id
6054: AND h.org_id = su.org_id
6089: + DECODE(l_include_tax_flag, 'Y',
6090: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
6091: )
6092: FROM oe_order_lines l
6093: , oe_order_headers_all h
6094: , hz_cust_site_uses_all su
6095: , hz_cust_acct_sites_all cas
6096: WHERE h.invoice_to_org_id = su.site_use_id
6097: AND h.org_id = su.org_id
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
6141: WHERE h.invoice_to_org_id = su.site_use_id
6142: AND h.org_id = su.org_id
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
6187: WHERE h.invoice_to_org_id = su.site_use_id
6188: AND h.org_id = su.org_id
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
6273: AND h.org_id = su.org_id /* MOAC_SQL_CHANGE */
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
6316: WHERE h.invoice_to_org_id = su.site_use_id
6317: AND h.org_id = su.org_id
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
6366: WHERE h.invoice_to_org_id = su.site_use_id
6367: AND h.org_id = su.org_id
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
6415: WHERE h.invoice_to_org_id = su.site_use_id
6416: AND h.org_id = su.org_id
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
6466: WHERE h.invoice_to_org_id = su.site_use_id
6467: AND h.org_id = su.org_id
6788: + DECODE(l_include_tax_flag, 'Y',
6789: NVL(l.tax_value,0), 0 )
6790: )
6791: FROM oe_order_lines l
6792: , oe_order_headers_all h
6793: WHERE h.invoice_to_org_id = p_site_use_id
6794: AND h.header_id = l.header_id
6795: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6796: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6824: + DECODE(l_include_tax_flag, 'Y',
6825: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
6826: )
6827: FROM oe_order_lines l
6828: , oe_order_headers_all h
6829: WHERE h.invoice_to_org_id = p_site_use_id
6830: AND h.header_id = l.header_id
6831: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6832: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6856: NVL(l.tax_value,0), 0
6857: )
6858: )
6859: FROM oe_order_lines l
6860: , oe_order_headers_all h
6861: WHERE h.invoice_to_org_id = p_site_use_id
6862: AND h.header_id = l.header_id
6863: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6864: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6896: + DECODE(l_include_tax_flag, 'Y',
6897: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
6898: )
6899: FROM oe_order_lines l
6900: , oe_order_headers_all h
6901: WHERE h.invoice_to_org_id = p_site_use_id
6902: AND h.header_id = l.header_id
6903: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6904: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6930: NVL(l.tax_value,0), 0
6931: )
6932: )
6933: FROM oe_order_lines l
6934: , oe_order_headers_all h
6935: WHERE h.invoice_to_org_id = p_site_use_id
6936: AND h.header_id = l.header_id
6937: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6938: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6967: + DECODE(l_include_tax_flag, 'Y',
6968: NVL(DECODE(l.line_category_code,'RETURN',(-1)*l.tax_value,l.tax_value),0),0 )
6969: )
6970: FROM oe_order_lines l
6971: , oe_order_headers_all h
6972: WHERE h.invoice_to_org_id = p_site_use_id
6973: AND h.header_id = l.header_id
6974: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
6975: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
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
7010: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7011: <= l_shipping_horizon
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
7052: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7053: <= l_shipping_horizon
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
7159: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7160: <= l_shipping_horizon
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
7205: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7206: <= l_shipping_horizon
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
7248: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7249: <= l_shipping_horizon
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
7293: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7294: <= l_shipping_horizon
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
7722: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
7761: AND cas.cust_acct_site_id = su.cust_acct_site_id
7789: Cursor cust_commitment_total_global
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
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
7838: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
7881: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
7920: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
7962: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8004: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8050: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8090: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8130: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8172: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8222: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8269: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8319: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8363: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8408: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8451: AND cas.cust_acct_site_id = su.cust_acct_site_id
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
8495: AND cas.cust_acct_site_id = su.cust_acct_site_id