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_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 89: FROM csi_item_instances

85: l_instance_number VARCHAR2(30):= substr(to_char(p_item_instance_id),1,30);
86: BEGIN
87: SELECT 'x'
88: INTO l_dummy
89: FROM csi_item_instances
90: WHERE instance_id = p_item_instance_id
91: OR instance_number = l_instance_number;
92: l_return_value := TRUE;
93: IF ( p_stack_err_msg = TRUE ) THEN

Line 172: FROM csi_item_instances

168: -- Added for eam integration
169: BEGIN
170: SELECT instance_number
171: INTO l_instance_number
172: FROM csi_item_instances
173: WHERE instance_number=p_instance_number;
174: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
175: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER',p_instance_number);
176: FND_MSG_PUB.Add;

Line 208: FROM csi_item_instances

204: -- Added for eam integration
205: BEGIN
206: SELECT instance_number
207: INTO l_instance_number
208: FROM csi_item_instances
209: WHERE instance_number = p_instance_number
210: AND instance_id <> p_item_instance_id;
211: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_NUM');
212: FND_MESSAGE.SET_TOKEN('INSTANCE_NUMBER',p_instance_number);

Line 1311: FROM csi_item_instances

1307: -- Check for fundamental uniqueness
1308: BEGIN
1309: SELECT 'x'
1310: INTO l_temp
1311: FROM csi_item_instances
1312: WHERE serial_number = p_serial_number
1313: AND inventory_item_id = p_inv_item_id
1314: AND instance_id <> l_instance_id
1315: AND ROWNUM = 1;

Line 1349: from CSI_ITEM_INSTANCES

1345: -- FOR base_rec in CTO_CUR(l_base_item_id) LOOP --Modified for bug 12952143 start
1346: Begin
1347: select 'x'
1348: into l_temp
1349: from CSI_ITEM_INSTANCES
1350: where serial_number = p_serial_number
1351: and inventory_item_id in
1352: (
1353: select inventory_item_id

Line 1387: FROM csi_item_instances

1383: THEN
1384: BEGIN
1385: SELECT 'x'
1386: INTO l_temp
1387: FROM csi_item_instances
1388: WHERE serial_number = p_serial_number
1389: AND last_vld_organization_id = p_inv_org_id
1390: AND instance_id <> l_instance_id
1391: AND ROWNUM = 1;

Line 1469: FROM csi_item_instances

1465: THEN
1466: BEGIN
1467: SELECT 'x'
1468: INTO l_temp
1469: FROM csi_item_instances
1470: WHERE serial_number = p_serial_number
1471: AND instance_id <> l_instance_id
1472: AND ROWNUM=1;
1473: EXCEPTION

Line 1599: FROM CSI_ITEM_INSTANCES

1595: -- Check for the fundamental uniqueness in Install Base
1596: BEGIN
1597: SELECT 'x'
1598: INTO l_temp
1599: FROM CSI_ITEM_INSTANCES
1600: WHERE inventory_item_id <> p_inv_item_id
1601: AND lot_number = p_lot_number
1602: AND instance_id <> p_instance_id;
1603: EXCEPTION

Line 1922: FROM csi_item_instances

1918: l_config_found:=NULL;
1919: BEGIN
1920: SELECT 'x'
1921: INTO l_config_found
1922: FROM csi_item_instances
1923: WHERE config_inst_hdr_id = p_config_inst_hdr_id
1924: AND config_inst_item_id = p_config_inst_item_id
1925: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
1926:

Line 1942: FROM csi_item_instances

1938: l_config_found:=NULL;
1939: BEGIN
1940: SELECT 'x'
1941: INTO l_config_found
1942: FROM csi_item_instances
1943: WHERE config_inst_hdr_id = p_config_inst_hdr_id
1944: AND config_inst_item_id = p_config_inst_item_id
1945: AND instance_id <> p_instance_id
1946: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));

Line 2509: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES

2505: p_instance_rec.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2506: THEN
2507: BEGIN
2508: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2509: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2510: SELECT '1'
2511: INTO l_count
2512: FROM csi_item_instances a
2513: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII

Line 2512: FROM csi_item_instances a

2508: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2509: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2510: SELECT '1'
2511: INTO l_count
2512: FROM csi_item_instances a
2513: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII
2514: -- WHERE a.instance_id = b.instance_id
2515: WHERE a.inventory_item_id = p_instance_rec.inventory_item_id
2516: AND a.inv_organization_id = p_instance_rec.inv_organization_id

Line 2521: AND a.rowid <> ( SELECT bb.rowid FROM csi_item_instances bb WHERE bb.instance_id = p_instance_rec.instance_id )

2517: AND a.inv_subinventory_name = p_instance_rec.inv_subinventory_name
2518: --Added location_type_code for bug 5514442--
2519: AND a.location_type_code = p_instance_rec.location_type_code
2520: AND a.instance_id <> p_instance_rec.instance_id
2521: AND a.rowid <> ( SELECT bb.rowid FROM csi_item_instances bb WHERE bb.instance_id = p_instance_rec.instance_id )
2522: AND a.serial_number IS NULL
2523: AND a.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2524: AND a.active_end_date IS NULL --code added for bug 5702911 --
2525: AND (

Line 3303: SELECT csi_item_instances_s.NEXTVAL

3299: RETURN NUMBER
3300: IS
3301: l_instance_id NUMBER;
3302: BEGIN
3303: SELECT csi_item_instances_s.NEXTVAL
3304: INTO l_instance_id
3305: FROM sys.dual;
3306: RETURN l_instance_id;
3307: END Get_instance_id;

Line 3324: SELECT csi_item_instances_h_s.NEXTVAL

3320: IS
3321: l_csi_item_instance_h_id NUMBER;
3322:
3323: BEGIN
3324: SELECT csi_item_instances_h_s.NEXTVAL
3325: INTO l_csi_item_instance_h_id
3326: FROM dual;
3327: RETURN l_csi_item_instance_h_id;
3328: EXCEPTION

Line 3352: FROM csi_item_instances

3348: l_return_value BOOLEAN := TRUE;
3349: BEGIN
3350: SELECT 'x'
3351: INTO l_dummy
3352: FROM csi_item_instances
3353: WHERE instance_id = p_Instance_id
3354: AND creation_complete_flag = 'Y';
3355: RETURN l_return_value;
3356: EXCEPTION

Line 3727: /* exists in csi_item_instances */

3723:
3724: /*-----------------------------------------------------------*/
3725: /* Procedure name: Is_InstanceID_Valid */
3726: /* Description : Check if the instance_id */
3727: /* exists in csi_item_instances */
3728: /*-----------------------------------------------------------*/
3729:
3730: FUNCTION Is_InstanceID_Valid
3731: (

Line 3744: FROM csi_item_instances

3740:
3741: BEGIN
3742: SELECT instance_id
3743: INTO l_instance_id
3744: FROM csi_item_instances
3745: WHERE instance_id = p_instance_id;
3746: l_return_value := TRUE;
3747: EXCEPTION
3748: WHEN NO_DATA_FOUND THEN

Line 3783: FROM csi_item_instances

3779:
3780: CURSOR c1 IS
3781: SELECT active_end_date,
3782: active_start_date
3783: FROM csi_item_instances
3784: WHERE instance_id = p_instance_id;
3785:
3786: BEGIN
3787: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN

Line 3981: FROM csi_item_instances

3977: p_instance_rec.instance_usage_code ,--Added for bug 2163942
3978: p_instance_rec.install_location_type_code ,
3979: p_instance_rec.install_location_id ,
3980: p_instance_rec.source_code --Added for bug 7156553, base bug 6990065
3981: FROM csi_item_instances
3982: WHERE instance_id = p_item_instance_id;
3983:
3984: RETURN TRUE;
3985:

Line 4205: FROM csi_item_instances

4201:
4202: CURSOR c1 IS
4203: SELECT active_start_date,
4204: active_end_date
4205: FROM csi_item_instances
4206: WHERE instance_id = p_instance_id
4207: and ((active_end_date is null) OR (To_Date(active_end_date,'DD-MM-RRRR HH24:MI') >= To_Date(sysdate,'DD-MM-RRRR HH24:MI'))); -- Bug 8586745
4208:
4209: BEGIN

Line 4268: FROM csi_item_instances

4264:
4265: CURSOR c1 IS
4266: SELECT active_end_date,
4267: active_start_date
4268: FROM csi_item_instances
4269: WHERE instance_id = p_instance_id
4270: and ((active_end_date is null) OR (To_Date(active_end_date,'DD-MM-RRRR HH24:MI') >= To_Date(sysdate,'DD-MM-RRRR HH24:MI'))); -- Bug 8586745
4271:
4272: BEGIN

Line 4871: FROM csi_item_instances

4867: SELECT location_id,
4868: location_type_code
4869: INTO l_header_tbl(1).location_id,
4870: l_header_tbl(1).location_type_code
4871: FROM csi_item_instances
4872: WHERE instance_id=l_header_tbl(1).instance_id;
4873: EXCEPTION
4874: WHEN OTHERS THEN
4875: NULL;

Line 4889: FROM csi_item_instances

4885: SELECT location_id,
4886: location_type_code
4887: INTO l_header_tbl(2).location_id,
4888: l_header_tbl(2).location_type_code
4889: FROM csi_item_instances
4890: WHERE instance_id=l_header_tbl(2).instance_id;
4891: EXCEPTION
4892: WHEN OTHERS THEN
4893: NULL;

Line 5237: from csi_item_instances_h

5233: l_min_txn_id := NULL;
5234: l_src_txn_date := NULL;
5235: select min(transaction_id)
5236: into l_min_txn_id
5237: from csi_item_instances_h
5238: where instance_id = p_instance_rec.instance_id
5239: and creation_date = (select min(creation_date) from csi_item_instances_h
5240: where instance_id = p_instance_rec.instance_id
5241: );

Line 5239: and creation_date = (select min(creation_date) from csi_item_instances_h

5235: select min(transaction_id)
5236: into l_min_txn_id
5237: from csi_item_instances_h
5238: where instance_id = p_instance_rec.instance_id
5239: and creation_date = (select min(creation_date) from csi_item_instances_h
5240: where instance_id = p_instance_rec.instance_id
5241: );
5242: --
5243: IF l_min_txn_id IS NOT NULL THEN