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.CSE_ASSET_MOVE_PKG dependencies on CSI_ITEM_INSTANCES

Line 569: csi_item_instances cii

565: FROM fa_distribution_history fdh,
566: csi_i_assets cia,
567: fa_additions fa,
568: fa_books fb,
569: csi_item_instances cii
570: WHERE cii.instance_id = c_instance_id
571: AND cia.instance_id = cii.instance_id
572: AND cia.fa_asset_id = fdh.asset_id
573: AND cia.fa_book_type_code = fdh.book_type_code

Line 1177: FROM csi_item_instances cii,

1173: ct.transaction_date ,
1174: mmt.transaction_id inv_material_transaction_id ,
1175: ct.object_version_number,
1176: cii.operational_status_code
1177: FROM csi_item_instances cii,
1178: csi_item_instances_h ciih,
1179: csi_transactions ct,
1180: mtl_material_transactions mmt,
1181: csi_txn_types ctt

Line 1178: csi_item_instances_h ciih,

1174: mmt.transaction_id inv_material_transaction_id ,
1175: ct.object_version_number,
1176: cii.operational_status_code
1177: FROM csi_item_instances cii,
1178: csi_item_instances_h ciih,
1179: csi_transactions ct,
1180: mtl_material_transactions mmt,
1181: csi_txn_types ctt
1182: WHERE ct.transaction_id = p_transaction_id

Line 1468: FROM csi_item_instances_h

1464: IF p_source_dest_flag = 'D' THEN
1465:
1466: SELECT creation_date
1467: INTO l_time_stamp
1468: FROM csi_item_instances_h
1469: WHERE transaction_id = l_transaction_id
1470: AND instance_id = p_instance_id;
1471:
1472: ELSIF p_source_dest_flag = 'S' THEN

Line 1476: FROM csi_item_instances_h

1472: ELSIF p_source_dest_flag = 'S' THEN
1473:
1474: /* SELECT max(transaction_id)
1475: INTO l_transaction_id
1476: FROM csi_item_instances_h
1477: WHERE instance_id = p_instance_id
1478: AND transaction_id < l_transaction_id;*/
1479:
1480: BEGIN --Bug 16014253 moved the query into begin-end block so that other transactions would get processed.

Line 1485: FROM csi_item_instances_h ciih,

1481: -- Bug 14623445 , looking prior transaction based on transaction_date.
1482: SELECT transaction_id
1483: INTO l_transaction_id
1484: FROM (SELECT ciih.transaction_id
1485: FROM csi_item_instances_h ciih,
1486: csi_transactions ct
1487: WHERE ciih.transaction_id = ct.transaction_id
1488: AND ciih.instance_id = p_instance_id
1489: AND ct.transaction_date < (SELECT transaction_date

Line 1500: FROM csi_item_instances_h

1496:
1497:
1498: SELECT creation_date
1499: INTO l_time_stamp
1500: FROM csi_item_instances_h
1501: WHERE transaction_id = l_transaction_id
1502: AND instance_id = p_instance_id;
1503:
1504: EXCEPTION

Line 1600: FROM csi_item_instances_h ciih,

1596: cii.inventory_item_id,
1597: cii.last_vld_organization_id,
1598: msi.serial_number_control_code,
1599: msi.primary_unit_of_measure
1600: FROM csi_item_instances_h ciih,
1601: csi_item_instances cii,
1602: mtl_system_items msi
1603: WHERE ciih.transaction_id = p_transaction_id
1604: AND cii.instance_id = ciih.instance_id

Line 1601: csi_item_instances cii,

1597: cii.last_vld_organization_id,
1598: msi.serial_number_control_code,
1599: msi.primary_unit_of_measure
1600: FROM csi_item_instances_h ciih,
1601: csi_item_instances cii,
1602: mtl_system_items msi
1603: WHERE ciih.transaction_id = p_transaction_id
1604: AND cii.instance_id = ciih.instance_id
1605: AND msi.inventory_item_id = cii.inventory_item_id

Line 1614: FROM csi_item_instances_h ciih,

1610: cii.serial_number,
1611: cii.instance_usage_code,
1612: nvl(ciih.old_quantity,0) old_quantity,
1613: nvl(ciih.new_quantity, 0) new_quantity
1614: FROM csi_item_instances_h ciih,
1615: csi_item_instances cii
1616: WHERE ciih.transaction_id = p_transaction_id
1617: AND cii.instance_id = ciih.instance_id
1618: AND cii.inventory_item_id = p_item_id;

Line 1615: csi_item_instances cii

1611: cii.instance_usage_code,
1612: nvl(ciih.old_quantity,0) old_quantity,
1613: nvl(ciih.new_quantity, 0) new_quantity
1614: FROM csi_item_instances_h ciih,
1615: csi_item_instances cii
1616: WHERE ciih.transaction_id = p_transaction_id
1617: AND cii.instance_id = ciih.instance_id
1618: AND cii.inventory_item_id = p_item_id;
1619:

Line 1626: FROM csi_item_instances_h ciih,

1622: cii.serial_number,
1623: cii.instance_usage_code,
1624: cit.transaction_id,
1625: cit.transaction_type_id
1626: FROM csi_item_instances_h ciih,
1627: csi_item_instances cii,
1628: csi_transactions cit,
1629: csi_i_assets cia
1630: WHERE cit.transaction_id <= p_transaction_id

Line 1627: csi_item_instances cii,

1623: cii.instance_usage_code,
1624: cit.transaction_id,
1625: cit.transaction_type_id
1626: FROM csi_item_instances_h ciih,
1627: csi_item_instances cii,
1628: csi_transactions cit,
1629: csi_i_assets cia
1630: WHERE cit.transaction_id <= p_transaction_id
1631: AND cii.inventory_item_id = p_item_id

Line 1900: FROM csi_item_instances_h a,

1896: BEGIN
1897:
1898: SELECT a.instance_id , a.transaction_id
1899: INTO l_instance_id, l_transaction_id
1900: FROM csi_item_instances_h a,
1901: ( SELECT b.transaction_id, b.instance_id
1902: FROM csi_inst_txn_details_v b
1903: WHERE b.transaction_id > l_transaction_id
1904: AND b.instance_id = l_instance_id

Line 2668: csi_item_instances_h ciih

2664: ,citdv.inv_material_transaction_id
2665: ,citdv.source_transaction_type
2666: ,citdv.object_version_number
2667: FROM csi_inst_txn_details_v citdv,
2668: csi_item_instances_h ciih
2669: WHERE citdv.transaction_id = ciih.transaction_id
2670: AND citdv.instance_id = ciih.instance_id
2671: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2672: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)

Line 2707: csi_item_instances_h ciih

2703: NVL(ciih.old_quantity,0)), 1) primary_units
2704: ,citdv.serial_number serial_number
2705: ,citdv.object_version_number
2706: FROM csi_inst_txn_details_v citdv ,
2707: csi_item_instances_h ciih
2708: WHERE citdv.transaction_id = c_src_transaction_id
2709: AND ciih.transaction_id = citdv.transaction_id
2710: AND ciih.instance_id = citdv.instance_id
2711: AND NVL(ciih.old_quantity,0) < NVL(ciih.new_quantity,0)

Line 3313: csi_item_instances_h ciih,

3309: ct.transaction_date,
3310: cii.inventory_revision,
3311: cii.instance_usage_code
3312: FROM csi_transactions ct,
3313: csi_item_instances_h ciih,
3314: csi_item_instances cii
3315: WHERE ct.transaction_id = p_transaction_id
3316: AND ciih.transaction_id = ct.transaction_id
3317: AND cii.instance_id = ciih.instance_id

Line 3314: csi_item_instances cii

3310: cii.inventory_revision,
3311: cii.instance_usage_code
3312: FROM csi_transactions ct,
3313: csi_item_instances_h ciih,
3314: csi_item_instances cii
3315: WHERE ct.transaction_id = p_transaction_id
3316: AND ciih.transaction_id = ct.transaction_id
3317: AND cii.instance_id = ciih.instance_id
3318: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)

Line 3359: csi_item_instances_h ciih

3355: ,citdv.transaction_quantity
3356: ,citdv.source_transaction_type
3357: FROM csi_inst_txn_details_v citdv,
3358: mtl_material_transactions mmt,
3359: csi_item_instances_h ciih
3360: WHERE mmt.inventory_item_id = c_inv_item_id
3361: AND mmt.organization_id = c_inv_org_id
3362: AND mmt.shipment_number = c_shipment_number
3363: AND citdv.transaction_id = ciih.transaction_id

Line 3391: csi_item_instances_h ciih ,

3387: ct.transaction_date,
3388: cii.instance_usage_code,
3389: ct.transaction_quantity
3390: FROM csi_transactions ct,
3391: csi_item_instances_h ciih ,
3392: csi_item_instances cii
3393: WHERE ct.transaction_id = p_transaction_id
3394: AND ciih.transaction_id = ct.transaction_id
3395: AND cii.instance_id = ciih.instance_id

Line 3392: csi_item_instances cii

3388: cii.instance_usage_code,
3389: ct.transaction_quantity
3390: FROM csi_transactions ct,
3391: csi_item_instances_h ciih ,
3392: csi_item_instances cii
3393: WHERE ct.transaction_id = p_transaction_id
3394: AND ciih.transaction_id = ct.transaction_id
3395: AND cii.instance_id = ciih.instance_id
3396: AND cii.serial_number is NOT NULL

Line 3430: csi_item_instances_h ciih,

3426: ,citdv.transaction_quantity
3427: ,citdv.source_transaction_type
3428: ,citdv.inventory_item_id
3429: FROM csi_inst_txn_details_v citdv,
3430: csi_item_instances_h ciih,
3431: mtl_material_transactions mmt
3432: WHERE mmt.inventory_item_id = c_inv_item_id
3433: AND citdv.inv_material_transaction_id = mmt.transaction_id
3434: AND mmt.organization_id = c_inv_org_id

Line 3833: FROM csi_item_instances cii,

3829: SELECT cii.inventory_item_id,
3830: cii.last_vld_organization_id
3831: INTO l_inventory_item_id,
3832: l_organization_id
3833: FROM csi_item_instances cii,
3834: csi_item_instances_h ciih
3835: WHERE ciih.transaction_id = p_csi_txn_rec.transaction_id
3836: AND cii.instance_id = ciih.instance_id
3837: AND rownum = 1;

Line 3834: csi_item_instances_h ciih

3830: cii.last_vld_organization_id
3831: INTO l_inventory_item_id,
3832: l_organization_id
3833: FROM csi_item_instances cii,
3834: csi_item_instances_h ciih
3835: WHERE ciih.transaction_id = p_csi_txn_rec.transaction_id
3836: AND cii.instance_id = ciih.instance_id
3837: AND rownum = 1;
3838:

Line 3887: FROM csi_item_instances_h CIIH,

3883: IF l_serial_code IN (2, 5) THEN
3884: BEGIN
3885: SELECT 'Y'
3886: INTO l_asset_exists
3887: FROM csi_item_instances_h CIIH,
3888: csi_item_instances CII,
3889: csi_i_assets cia
3890: WHERE CIIH.transaction_id = p_csi_txn_rec.transaction_id
3891: AND CIIH.instance_id = CII.instance_id

Line 3888: csi_item_instances CII,

3884: BEGIN
3885: SELECT 'Y'
3886: INTO l_asset_exists
3887: FROM csi_item_instances_h CIIH,
3888: csi_item_instances CII,
3889: csi_i_assets cia
3890: WHERE CIIH.transaction_id = p_csi_txn_rec.transaction_id
3891: AND CIIH.instance_id = CII.instance_id
3892: AND CII.instance_id = CIA.instance_id

Line 3905: FROM csi_item_instances_h CIIH,

3901: ELSE
3902: BEGIN
3903: SELECT 'Y'
3904: INTO l_asset_exists
3905: FROM csi_item_instances_h CIIH,
3906: csi_item_instances CII,
3907: csi_i_assets CIA
3908: WHERE CIIH.transaction_id = p_csi_txn_rec.transaction_id
3909: AND CII.instance_id = CIIH.instance_id

Line 3906: csi_item_instances CII,

3902: BEGIN
3903: SELECT 'Y'
3904: INTO l_asset_exists
3905: FROM csi_item_instances_h CIIH,
3906: csi_item_instances CII,
3907: csi_i_assets CIA
3908: WHERE CIIH.transaction_id = p_csi_txn_rec.transaction_id
3909: AND CII.instance_id = CIIH.instance_id
3910: AND CII.inventory_item_id = l_inventory_item_id

Line 4240: FROM csi_item_instances_h ciih,

4236: ciih.old_location_type_code,
4237: ciih.old_location_id,
4238: ciih.new_location_type_code,
4239: ciih.new_location_id
4240: FROM csi_item_instances_h ciih,
4241: csi_item_instances cii
4242: WHERE ciih.transaction_id = p_csi_txn_id
4243: AND cii.instance_id = ciih.instance_id
4244: AND cii.inventory_item_id = p_inventory_item_id;

Line 4241: csi_item_instances cii

4237: ciih.old_location_id,
4238: ciih.new_location_type_code,
4239: ciih.new_location_id
4240: FROM csi_item_instances_h ciih,
4241: csi_item_instances cii
4242: WHERE ciih.transaction_id = p_csi_txn_id
4243: AND cii.instance_id = ciih.instance_id
4244: AND cii.inventory_item_id = p_inventory_item_id;
4245:

Line 4268: csi_item_instances cii,

4264:
4265: CURSOR pend_txn_cur(p_instance_id IN number, p_csi_txn_id IN number, p_inv_item_id in NUMBER) IS
4266: SELECT ct.transaction_id
4267: FROM csi_transactions ct,
4268: csi_item_instances cii,
4269: csi_item_instances_h ciih
4270: WHERE ciih.instance_id = p_instance_id
4271: AND ciih.transaction_id < p_csi_txn_id
4272: AND cii.instance_id = ciih.instance_id

Line 4269: csi_item_instances_h ciih

4265: CURSOR pend_txn_cur(p_instance_id IN number, p_csi_txn_id IN number, p_inv_item_id in NUMBER) IS
4266: SELECT ct.transaction_id
4267: FROM csi_transactions ct,
4268: csi_item_instances cii,
4269: csi_item_instances_h ciih
4270: WHERE ciih.instance_id = p_instance_id
4271: AND ciih.transaction_id < p_csi_txn_id
4272: AND cii.instance_id = ciih.instance_id
4273: AND cii.inventory_item_id = p_inv_item_id

Line 4528: FROM csi_item_instances_h ciih,

4524: 326) -- PROJECT_CONTRACT_SHIPMENT
4525: AND ct.transaction_status_code = 'PENDING'
4526: AND EXISTS (
4527: SELECT 1
4528: FROM csi_item_instances_h ciih,
4529: csi_item_instances cii
4530: WHERE ciih.transaction_id = ct.transaction_id
4531: AND cii.instance_id = ciih.instance_id
4532: AND cii.inventory_item_id = nvl(p_inventory_item_id, cii.inventory_item_id))

Line 4529: csi_item_instances cii

4525: AND ct.transaction_status_code = 'PENDING'
4526: AND EXISTS (
4527: SELECT 1
4528: FROM csi_item_instances_h ciih,
4529: csi_item_instances cii
4530: WHERE ciih.transaction_id = ct.transaction_id
4531: AND cii.instance_id = ciih.instance_id
4532: AND cii.inventory_item_id = nvl(p_inventory_item_id, cii.inventory_item_id))
4533: ORDER BY ct.creation_date;