755: from ra_customer_trx_all
756: where customer_trx_id = cp_trx_id;
757:
758: --added by zhiwei.xin for OM begin
759: cursor c_get_om_org_id(cp_trx_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
760: is
761: select org_id
762: from oe_order_headers_all
763: where header_id = cp_trx_id;
758: --added by zhiwei.xin for OM begin
759: cursor c_get_om_org_id(cp_trx_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
760: is
761: select org_id
762: from oe_order_headers_all
763: where header_id = cp_trx_id;
764: --added by zhiwei.xin for OM end.
765:
766: --Added by Wenqiong for PO integration begin