DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 196: INSERT INTO CSI_ITEM_INSTANCES_H

192: End;
193:
194: /* insert record into history table */
195: --
196: INSERT INTO CSI_ITEM_INSTANCES_H
197: (
198: INSTANCE_HISTORY_ID
199: ,INSTANCE_ID
200: ,TRANSACTION_ID

Line 214: CSI_ITEM_INSTANCES_H_S.nextval

210: ,OLD_INST_LOC_ID
211: ,NEW_INST_LOC_ID
212: )
213: SELECT
214: CSI_ITEM_INSTANCES_H_S.nextval
215: ,cii.INSTANCE_ID
216: ,v_transaction_id
217: ,decode( cii.location_id, p_from_fk_id, cii.location_id, null )
218: ,decode( cii.location_id, p_from_fk_id, p_to_fk_id, null )