eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_GRP dependencies on CSI_ITEM_INSTANCES

Line 818: select CSI_ITEM_INSTANCES_H_S.nextval

814: l_count NUMBER;
815: l_hist_id NUMBER;
816: BEGIN
817: l_count := p_inst_hist_tbl.count + 1;
818: select CSI_ITEM_INSTANCES_H_S.nextval
819: into l_hist_id
820: from sys.dual;
821: p_inst_hist_tbl(l_count).instance_id := p_inst_rec.instance_id;
822: p_inst_hist_tbl(l_count).instance_history_id := l_hist_id;

Line 3147: INSERT INTO CSI_ITEM_INSTANCES(

3143: );
3144: --
3145: l_ctr := l_inst_rec_tab.instance_id.count;
3146: FORALL i in 1 .. l_ctr
3147: INSERT INTO CSI_ITEM_INSTANCES(
3148: INSTANCE_ID,
3149: INSTANCE_NUMBER,
3150: EXTERNAL_REFERENCE,
3151: INVENTORY_ITEM_ID,

Line 3478: INSERT INTO CSI_ITEM_INSTANCES_H(

3474: --
3475: l_ctr := l_inst_hist_rec_tab.instance_history_id.count;
3476: --
3477: FORALL i in 1 .. l_ctr
3478: INSERT INTO CSI_ITEM_INSTANCES_H(
3479: INSTANCE_HISTORY_ID,
3480: INSTANCE_ID,
3481: TRANSACTION_ID,
3482: OLD_INSTANCE_NUMBER,

Line 4379: UPDATE CSI_ITEM_INSTANCES

4375: --
4376: l_ctr := l_owner_pty_acct_rec_tab.instance_id.count;
4377: --
4378: FORALL i in 1 .. l_ctr
4379: UPDATE CSI_ITEM_INSTANCES
4380: SET owner_party_id = l_owner_pty_acct_rec_tab.party_id(i)
4381: ,owner_party_source_table = l_owner_pty_acct_rec_tab.party_source_table(i)
4382: ,owner_party_account_id = l_owner_pty_acct_rec_tab.account_id(i)
4383: WHERE instance_id = l_owner_pty_acct_rec_tab.instance_id(i);

Line 5968: FROM csi_item_instances

5964: OTHER_ERROR EXCEPTION; -- Added for bug 3579121(rel 11.5.9)
5965:
5966: CURSOR instance_csr (p_ins_id IN NUMBER) IS
5967: SELECT *
5968: FROM csi_item_instances
5969: WHERE instance_id = p_ins_id;
5970: --
5971: l_instance_csr instance_csr%ROWTYPE;
5972: --

Line 6892: -- that looks at csi_item_instances cannot be used directly. Hence calling the

6888: --
6889: -- Asset Open Interface should have this validation as False
6890: --
6891: -- Since the item instance is not yet created, the set_fa_sync_flag routine
6892: -- that looks at csi_item_instances cannot be used directly. Hence calling the
6893: -- same with the location_id.
6894: --
6895: IF p_asset_assignment_tbl(tab_row).fa_sync_validation_reqd = fnd_api.g_true THEN
6896: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN

Line 7538: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);

7534: -- Delete the Instances failed in Counter and Contracts creation.
7535: IF l_del_inst_tbl.count > 0 THEN
7536: BEGIN
7537: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7538: DELETE FROM CSI_ITEM_INSTANCES WHERE instance_id = l_del_inst_tbl(j);
7539: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7540: DELETE FROM CSI_IP_ACCOUNTS WHERE instance_party_id in (SELECT instance_party_id
7541: from CSI_I_PARTIES WHERE instance_id = l_del_inst_tbl(j));
7542: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST

Line 7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);

7551: DELETE FROM CSI_IEA_VALUES WHERE instance_id = l_del_inst_tbl(j);
7552: FORALL j in l_del_inst_tbl.FIRST .. l_del_inst_tbl.LAST
7553: DELETE FROM CSI_I_ASSETS WHERE instance_id = l_del_inst_tbl(j);
7554: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7555: DELETE FROM CSI_ITEM_INSTANCES_H WHERE transaction_id = l_del_txn_tbl(j);
7556: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7557: DELETE FROM CSI_I_PARTIES_H WHERE transaction_id = l_del_txn_tbl(j);
7558: FORALL j in l_del_txn_tbl.FIRST .. l_del_txn_tbl.LAST
7559: DELETE FROM CSI_IP_ACCOUNTS_H WHERE transaction_id = l_del_txn_tbl(j);

Line 7835: from CSI_ITEM_INSTANCES

7831: ,OWNER_PARTY_ACCOUNT_ID
7832: ,LAST_VLD_ORGANIZATION_ID
7833: ,MIGRATED_FLAG
7834: ,NULL PROCESSED_FLAG
7835: from CSI_ITEM_INSTANCES
7836: where instance_id = p_ins_id;
7837: --
7838: l_instance_csr instance_csr%ROWTYPE;
7839: --

Line 7920: FROM CSI_ITEM_INSTANCES

7916: ,OWNER_PARTY_ACCOUNT_ID
7917: ,LAST_VLD_ORGANIZATION_ID
7918: ,MIGRATED_FLAG
7919: ,NULL PROCESSED_FLAG
7920: FROM CSI_ITEM_INSTANCES
7921: WHERE instance_id = p_ins_id;
7922: l_old_ins_csr old_ins_csr%ROWTYPE;
7923: --
7924: l_iface_error_text VARCHAR2(2000);

Line 8094: from CSI_ITEM_INSTANCES

8090: --
8091: IF l_child_exists = 'Y' THEN -- Call update API with the New object version Number
8092: select object_version_number
8093: into l_new_instance_rec.object_version_number
8094: from CSI_ITEM_INSTANCES
8095: where instance_id = l_new_instance_rec.instance_id;
8096: END IF;
8097: -- Call the update_item_instance private API to update the instances
8098: l_iface_error_text := NULL;

Line 8721: from CSI_ITEM_INSTANCES

8717: l_new_instance_rec := l_temp_instance_rec;
8718: Begin
8719: select active_end_date,object_version_number
8720: into l_new_instance_rec.active_end_date,l_new_instance_rec.object_version_number
8721: from CSI_ITEM_INSTANCES
8722: where instance_id = l_exp_tbl(k).instance_id;
8723: Exception
8724: when no_data_found then
8725: p_instance_tbl(k).processed_flag := 'E';

Line 10252: select CSI_ITEM_INSTANCES_S.nextval

10248: For ins_tab in l_ins_tbl.FIRST .. l_ins_tbl.LAST
10249: Loop
10250: l_grp_ctr := l_grp_ctr + 1;
10251: l_grp_ins_tbl(l_grp_ctr) := p_instance_rec;
10252: select CSI_ITEM_INSTANCES_S.nextval
10253: into l_grp_ins_tbl(l_grp_ctr).instance_id
10254: from dual;
10255: --
10256: l_grp_ins_tbl(l_grp_ctr).instance_number := l_grp_ins_tbl(l_grp_ctr).instance_id;