[Home] [Help]
186:
187: SELECT su.site_use_id
188: INTO l_site_use_id
189: FROM hz_cust_acct_sites cas
190: , hz_cust_site_uses_all su
191: WHERE cas.cust_acct_site_id = su.cust_acct_site_id
192: AND su.cust_acct_site_id = l_cust_acct_site_id
193: AND su.site_use_code = 'DRAWEE' ; /* MOAC_SQL_CHANGE */
194:
3146: CURSOR trx_curr_csr_customer IS
3147: SELECT soh.transactional_curr_code user_code
3148: FROM oe_order_headers soh
3149: , hz_cust_acct_sites_all cas
3150: , hz_cust_site_uses_all su
3151: WHERE soh.org_id = su.org_id
3152: AND soh.invoice_to_org_id = su.site_use_id
3153: AND cas.cust_acct_site_id = su.cust_acct_site_id
3154: AND cas.cust_account_id = p_entity_id
3156: UNION
3157: SELECT pay.invoice_currency_code user_code
3158: FROM ar_payment_schedules pay
3159: , hz_cust_acct_sites_all cas
3160: , hz_cust_site_uses_all su
3161: WHERE pay.org_id = su.org_id
3162: AND pay.customer_site_use_id = su.site_use_id
3163: AND cas.cust_acct_site_id = su.cust_acct_site_id
3164: AND cas.cust_account_id = p_entity_id
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
3182: AND cas.cust_account_id = p_entity_id
3183: GROUP BY transactional_curr_code
3184: UNION
3185: SELECT pay.invoice_currency_code user_code
3186: FROM ar_payment_schedules_ALL pay
3187: , hz_cust_acct_sites_ALL cas
3188: , hz_cust_site_uses_ALL su
3189: WHERE pay.customer_site_use_id = su.site_use_id
3190: AND cas.cust_acct_site_id = su.cust_acct_site_id
3191: AND cas.cust_account_id = p_entity_id
3192: GROUP BY invoice_currency_code
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
4556: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4557: AND h.header_id = l.header_id
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
4599: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4600: AND h.header_id = l.header_id
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
4641: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
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
4708: WHERE h.header_id = p_header_id
4709: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
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
4768: WHERE h.header_id = p_header_id
4769: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5908:
5909: CURSOR cust_ar_balance (p_curr_code IN VARCHAR2 default NULL) IS
5910: SELECT SUM(NVL(ps.amount_due_remaining,0))
5911: FROM ar_payment_schedules ps
5912: , hz_cust_site_uses_all su
5913: -- , hz_cust_acct_sites_all cas -- Commented Bug#11827225
5914: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5915: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */
5916: AND ps.status = 'OP'
5930:
5931: CURSOR cust_BR_balance (p_curr_code IN VARCHAR2 default NULL) IS
5932: SELECT SUM(NVL(ps.amount_due_remaining,0))
5933: FROM ar_payment_schedules ps
5934: , hz_cust_site_uses_all su
5935: -- , hz_cust_acct_sites_all cas -- Commented Bug#11827225
5936: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5937: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */
5938: AND ps.status = 'OP'
5950: CURSOR cust_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5951: SELECT SUM(NVL(crh.amount,0))
5952: FROM ar_cash_receipt_history crh
5953: , ar_cash_receipts_all cr
5954: , hz_cust_site_uses_all su
5955: , hz_cust_acct_sites_all cas
5956: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5957: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */
5958: AND NVL(cr.confirmed_flag,'Y') = 'Y'
5991: CURSOR cust_br_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5992: SELECT SUM(NVL(crh.amount,0))
5993: FROM ar_cash_receipt_history crh
5994: , ar_cash_receipts_all cr
5995: , hz_cust_site_uses_all su
5996: , hz_cust_acct_sites_all cas
5997: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5998: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */
5999: AND NVL(cr.confirmed_flag,'Y') = '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
6040: AND h.org_id = su.org_id
6041: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6080: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6114: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6181: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6224: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6263: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6306: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6354: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6404: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6449: AND h.org_id = su.org_id /* MOAC_SQL_CHANGE */
6450: AND su.cust_acct_site_id = cas.cust_acct_site_id
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 */
6497: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6545: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6599: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6652: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6707: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6755: AND h.org_id = su.org_id
6756: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6804: AND h.org_id = su.org_id
6805: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6852: AND h.org_id = su.org_id
6853: AND su.cust_acct_site_id = cas.cust_acct_site_id
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
6901: AND h.org_id = su.org_id
6902: AND su.cust_acct_site_id = cas.cust_acct_site_id
6963: CURSOR site_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
6964: SELECT SUM(NVL(crh.amount,0))
6965: FROM ar_cash_receipt_history crh
6966: , ar_cash_receipts_all cr
6967: , hz_cust_site_uses_all s
6968: , hz_cust_acct_sites_all a
6969: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6970: AND crh.org_id = cr.org_id
6971: AND crh.current_record_flag = 'Y'
7805: /*CURSOR cust_ar_balance_global
7806: (p_curr_code IN VARCHAR2 default NULL) IS
7807: SELECT SUM(NVL(ps.amount_due_remaining,0))
7808: FROM ar_payment_schedules_ALL ps
7809: , hz_cust_site_uses_ALL su
7810: , hz_cust_acct_sites_ALL cas
7811: WHERE ps.customer_site_use_id = su.site_use_id
7812: AND ps.status = 'OP'
7813: AND cas.cust_acct_site_id = su.cust_acct_site_id
7824: (p_curr_code IN VARCHAR2 default NULL) IS
7825: SELECT SUM(NVL(amount_due_remaining,0)) FROM (
7826: SELECT NVL(ps.amount_due_remaining,0) amount_due_remaining,ps.PAYMENT_SCHEDULE_ID
7827: FROM ar_payment_schedules_ALL ps
7828: , hz_cust_site_uses_ALL su
7829: , hz_cust_acct_sites_ALL cas
7830: WHERE ps.customer_site_use_id = su.site_use_id
7831: AND ps.status = 'OP'
7832: AND cas.cust_acct_site_id = su.cust_acct_site_id
7858: (p_curr_code IN VARCHAR2 default NULL) IS
7859: SELECT SUM(NVL(crh.amount,0))
7860: FROM ar_cash_receipt_history_ALL crh
7861: , ar_cash_receipts_ALL cr
7862: , hz_cust_site_uses_ALL su
7863: , hz_cust_acct_sites_ALL cas
7864: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7865: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7866: AND crh.current_record_flag = 'Y'
7896: SELECT SUM(NVL(amount,0)) FROM (
7897: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7898: FROM ar_cash_receipt_history_ALL crh
7899: , ar_cash_receipts_ALL cr
7900: , hz_cust_site_uses_ALL su
7901: , hz_cust_acct_sites_ALL cas
7902: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7903: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7904: AND crh.current_record_flag = 'Y'
7964: CURSOR cust_br_balance_global
7965: (p_curr_code IN VARCHAR2 default NULL) IS
7966: SELECT SUM(NVL(ps.amount_due_remaining,0))
7967: FROM ar_payment_schedules_ALL ps
7968: , hz_cust_site_uses_ALL su
7969: -- , hz_cust_acct_sites_ALL cas -- Commented Bug#11827225
7970: WHERE ps.customer_site_use_id = su.site_use_id
7971: AND ps.status = 'OP'
7972: --AND cas.cust_acct_site_id = su.cust_acct_site_id -- Commented Bug#11827225
7981: (p_curr_code IN VARCHAR2 default NULL) IS
7982: SELECT SUM(NVL(crh.amount,0))
7983: FROM ar_cash_receipt_history_ALL crh
7984: , ar_cash_receipts_ALL cr
7985: , hz_cust_site_uses_ALL su
7986: , hz_cust_acct_sites_ALL cas
7987: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7988: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7989: AND crh.current_record_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
8028: AND cas.cust_account_id = p_customer_id
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
8067: AND cas.cust_account_id = p_customer_id
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
8104: AND cas.cust_account_id = p_customer_id
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
8144: AND cas.cust_account_id = p_customer_id
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
8187: AND cas.cust_account_id = p_customer_id
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
8226: AND cas.cust_account_id = p_customer_id
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
8268: AND cas.cust_account_id = p_customer_id
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
8313: AND cas.cust_account_id = p_customer_id
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
8363: AND cas.cust_account_id = p_customer_id
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
8407: AND cas.cust_account_id = p_customer_id
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
8451: AND cas.cust_account_id = p_customer_id
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
8497: AND cas.cust_account_id = p_customer_id
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
8551: AND cas.cust_account_id = p_customer_id
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
8602: AND cas.cust_account_id = p_customer_id
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
8656: AND cas.cust_account_id = p_customer_id
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
8704: AND cas.cust_account_id = p_customer_id
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
8753: AND cas.cust_account_id = p_customer_id
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
8800: AND cas.cust_account_id = p_customer_id
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
8848: AND cas.cust_account_id = p_customer_id