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 DUAL

Line 169: from dual

165: IF l_base_item_id IS NOT NULL THEN
166: Begin
167: select 1
168: into l_count
169: from dual
170: where exists (select 'x' from mtl_system_items_b msi
171: where msi.base_item_id = l_base_item_id
172: and msi.inventory_item_id = p_instance_tbl(j).inventory_item_id);
173: Exception

Line 823: from sys.dual;

819: BEGIN
820: l_count := p_inst_hist_tbl.count + 1;
821: select CSI_ITEM_INSTANCES_H_S.nextval
822: into l_hist_id
823: from sys.dual;
824: p_inst_hist_tbl(l_count).instance_id := p_inst_rec.instance_id;
825: p_inst_hist_tbl(l_count).instance_history_id := l_hist_id;
826: p_inst_hist_tbl(l_count).transaction_id := p_txn_id;
827: p_inst_hist_tbl(l_count).old_instance_number := null;

Line 1037: from sys.dual;

1033: BEGIN
1034: l_count := p_ver_label_history_tbl.count + 1;
1035: select CSI_I_VERSION_LABELS_H_S.nextval
1036: into l_hist_id
1037: from sys.dual;
1038: --
1039: p_ver_label_history_tbl(l_count).VERSION_LABEL_HISTORY_ID := l_hist_id;
1040: p_ver_label_history_tbl(l_count).VERSION_LABEL_ID := p_version_label_rec.VERSION_LABEL_ID;
1041: p_ver_label_history_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1097: from sys.dual;

1093: BEGIN
1094: l_count := p_party_hist_tbl.count + 1;
1095: select CSI_I_PARTIES_H_S.nextval
1096: into l_hist_id
1097: from sys.dual;
1098: --
1099: p_party_hist_tbl(l_count).INSTANCE_PARTY_HISTORY_ID := l_hist_id;
1100: p_party_hist_tbl(l_count).INSTANCE_PARTY_ID := p_party_rec.INSTANCE_PARTY_ID;
1101: p_party_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1166: from sys.dual;

1162: BEGIN
1163: l_count := p_acct_hist_tbl.count + 1;
1164: select CSI_IP_ACCOUNTS_H_S.nextval
1165: into l_hist_id
1166: from sys.dual;
1167: --
1168: p_acct_hist_tbl(l_count).IP_ACCOUNT_HISTORY_ID := l_hist_id;
1169: p_acct_hist_tbl(l_count).IP_ACCOUNT_ID := p_acct_rec.IP_ACCOUNT_ID;
1170: p_acct_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1230: from sys.dual;

1226: BEGIN
1227: l_count := p_org_hist_tbl.count + 1;
1228: select CSI_I_ORG_ASSIGNMENTS_H_S.nextval
1229: into l_hist_id
1230: from sys.dual;
1231:
1232: p_org_hist_tbl(l_count).instance_ou_history_id := l_hist_id;
1233: p_org_hist_tbl(l_count).instance_ou_id := p_org_rec.instance_ou_id;
1234: p_org_hist_tbl(l_count).transaction_id := p_txn_id;

Line 1290: from sys.dual;

1286: BEGIN
1287: l_count := p_pricing_hist_tbl.count + 1;
1288: select CSI_I_PRICING_ATTRIBS_H_S.nextval
1289: into l_hist_id
1290: from sys.dual;
1291:
1292: p_pricing_hist_tbl(l_count).PRICE_ATTRIB_HISTORY_ID := l_hist_id;
1293: p_pricing_hist_tbl(l_count).PRICING_ATTRIBUTE_ID := p_pricing_rec.pricing_attribute_id;
1294: p_pricing_hist_tbl(l_count).TRANSACTION_ID := p_txn_id;

Line 1548: from sys.dual;

1544: BEGIN
1545: l_count := p_ext_attr_hist_tbl.count + 1;
1546: select CSI_IEA_VALUES_H_S.nextval
1547: into l_hist_id
1548: from sys.dual;
1549:
1550: p_ext_attr_hist_tbl(l_count).attribute_value_history_id := l_hist_id;
1551: p_ext_attr_hist_tbl(l_count).attribute_value_id := p_ext_attr_rec.attribute_value_id;
1552: p_ext_attr_hist_tbl(l_count).transaction_id := p_txn_id;

Line 1608: from sys.dual;

1604: BEGIN
1605: l_count := p_asset_hist_tbl.count + 1;
1606: select CSI_I_ASSETS_H_S.nextval
1607: into l_hist_id
1608: from sys.dual;
1609:
1610: p_asset_hist_tbl(l_count).instance_asset_history_id := l_hist_id;
1611: p_asset_hist_tbl(l_count).transaction_id := p_txn_id;
1612: p_asset_hist_tbl(l_count).instance_asset_id := p_asset_rec.instance_asset_id;

Line 7319: from sys.dual;

7315: IF p_txn_tbl(inst_tab_row).transaction_id IS NULL OR
7316: p_txn_tbl(inst_tab_row).transaction_id = FND_API.G_MISS_NUM THEN
7317: select CSI_TRANSACTIONS_S.nextval
7318: into p_txn_tbl(inst_tab_row).transaction_id
7319: from sys.dual;
7320: END IF;
7321: --
7322: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
7323: --

Line 7326: from sys.dual;

7322: l_bulk_txn_tbl(l_bulk_inst_count) := p_txn_tbl(inst_tab_row);
7323: --
7324: select CSI_I_VERSION_LABELS_S.nextval
7325: into l_bulk_version_label_tbl(l_bulk_inst_count).version_label_id
7326: from sys.dual;
7327: --
7328: l_bulk_version_label_tbl(l_bulk_inst_count).version_label := p_instance_tbl(inst_tab_row).version_label;
7329: l_bulk_version_label_tbl(l_bulk_inst_count).active_start_date := p_instance_tbl(inst_tab_row).active_start_date;
7330: l_bulk_version_label_tbl(l_bulk_inst_count).date_time_stamp := SYSDATE;

Line 7851: into l_ctr_id(l_counter) from sys.dual;

7847: ELSE
7848: -- Build the PL/SQL table for Inserting into Counters Temp table
7849: l_counter := l_counter + 1;
7850: select CSI_CTR_UPLOAD_INSTANCES_S.nextval
7851: into l_ctr_id(l_counter) from sys.dual;
7852: --
7853: l_ctr_ins_id(l_counter) := p_instance_tbl(inst_row).instance_id;
7854: l_ctr_item_id(l_counter) := p_instance_tbl(inst_row).inventory_item_id;
7855: l_ctr_org_id(l_counter) := p_instance_tbl(inst_row).vld_organization_id;

Line 10819: from dual;

10815: l_grp_ctr := l_grp_ctr + 1;
10816: l_grp_ins_tbl(l_grp_ctr) := p_instance_rec;
10817: select CSI_ITEM_INSTANCES_S.nextval
10818: into l_grp_ins_tbl(l_grp_ctr).instance_id
10819: from dual;
10820: --
10821:
10822: csi_gen_utility_pvt.put_line('Current vld org id '||l_grp_ins_tbl(l_grp_ctr).vld_organization_id);
10823: csi_gen_utility_pvt.put_line('Warehouse org id from BOM '||l_ins_tbl(ins_tab).vld_organization_id);