coin_adjustment

IF (pFlgTagging = vAll OR pFlgTagging = vFlgYes) THEN

		EXECUTE '
			INSERT INTO tt_raw_data_detail_coin_system(
				session_id, tenant_id, tag_type, partner_id,
				doc_id, doc_type_id, doc_no, doc_date,
				ref_id, ref_doc_type_id, ref_doc_no,
				ref_doc_date, promo_id, promo_code,
				sub_promo_id, sub_promo_code,
				product_launching_id, launching_code,
				brand_id, qty, price_so, sell_price, discount, total_amount,
				coin_promo, coin_sub_promo, coin_launching,
				coin_periodic_adjustment, coin_total,
				raw_data, salesman_id
			)
			SELECT $1, A.tenant_id, $6, A.partner_id,
				C.adjustment_coin_id, C.doc_type_id, C.doc_no, C.doc_date,
				$9, $9, $7,
				$7, A.promo_id, B.promo_code,
				$9, $7,
				$9, $7,
				$9, $8, $8, $8, $8, $8,
				A.coin_adjustment, $8, $8,
				$8, A.coin_adjustment,
				$10, A.salesman_id
			FROM sl_log_coin_promo_balance A
			INNER JOIN m_promo B ON A.promo_id = B.promo_id
			INNER JOIN sl_adjustment_coin C ON A.ref_id = C.adjustment_coin_id AND A.ref_doc_type_id = C.doc_type_id
			WHERE A.tenant_id = $2
				AND A.ref_doc_type_id = $3
				AND A.promo_id = $4
				AND B.ou_id = $5
				'||vFilterCustomer||';'

		USING pSessionId, pTenantId, vDocTypeIdACC, pPromoId, pOuId, vHistoryLogCoinType, vEmptyString, vEmptyAmount, vEmptyId, vRawDataACC;

	END IF;