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_I_ASSETS

Line 566: csi_i_assets cia,

562: fdh.assigned_to fa_employee_id,
563: cia.asset_quantity instance_asset_qty,
564: cia.instance_asset_id
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

Line 700: FROM csi_i_assets cia

696: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;
697:
698: CURSOR inst_asset_cur (c_instance_asset_id IN NUMBER) IS
699: SELECT cia.object_version_number
700: FROM csi_i_assets cia
701: WHERE cia.instance_asset_id = c_instance_asset_id ;
702:
703: BEGIN
704: x_return_status := fnd_api.g_ret_sts_success ;

Line 896: l_upd_csi_i_assets VARCHAR2(1);

892: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
893: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type ;
894: i PLS_INTEGER ;
895: l_transaction_units NUMBER ;
896: l_upd_csi_i_assets VARCHAR2(1);
897: l_hook_used number;
898: l_fnd_success VARCHAR2(1);
899: l_fnd_error VARCHAR2(1);
900: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;

Line 916: l_upd_csi_i_assets := 'N';

912: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
913: l_fnd_error := FND_API.G_RET_STS_ERROR;
914: x_return_status := l_fnd_success ;
915: l_calling_fn := 'OAT';
916: l_upd_csi_i_assets := 'N';
917:
918: IF p_src_fa_inst_dtls_rec.fa_location_id <> p_dest_fa_dist_rec.location_id THEN
919: debug('Source and Destination Location are different, perfroming Dist. Transfer');
920:

Line 1001: l_upd_csi_i_assets := 'Y';

997: l_error_msg := cse_util_pkg.dump_error_stack;
998: debug('Error :'||l_error_msg);
999: RAISE e_error ;
1000: END IF;
1001: l_upd_csi_i_assets := 'Y';
1002: ELSE
1003:
1004: IF p_src_fa_inst_dtls_rec.instance_id = p_dest_move_trans_rec.instance_id THEN
1005: ---As FA Locations are same and also the Instance ID's are same, no need to take any action.

Line 1007: l_upd_csi_i_assets := 'N' ;

1003:
1004: IF p_src_fa_inst_dtls_rec.instance_id = p_dest_move_trans_rec.instance_id THEN
1005: ---As FA Locations are same and also the Instance ID's are same, no need to take any action.
1006: debug('Both Source and Destination Location and also Instances are same, no updates are required');
1007: l_upd_csi_i_assets := 'N' ;
1008: ELSE
1009: debug('Both Source and Destination Location are same but Instances are different, updating just CIA');
1010: l_upd_csi_i_assets := 'Y';
1011: END IF ;

Line 1010: l_upd_csi_i_assets := 'Y';

1006: debug('Both Source and Destination Location and also Instances are same, no updates are required');
1007: l_upd_csi_i_assets := 'N' ;
1008: ELSE
1009: debug('Both Source and Destination Location are same but Instances are different, updating just CIA');
1010: l_upd_csi_i_assets := 'Y';
1011: END IF ;
1012: END IF ; --p_src_fa_inst_dtls_rec.fa_location_id <> p_dest_fa_location_id
1013:
1014: IF l_upd_csi_i_assets = 'Y' THEN

Line 1014: IF l_upd_csi_i_assets = 'Y' THEN

1010: l_upd_csi_i_assets := 'Y';
1011: END IF ;
1012: END IF ; --p_src_fa_inst_dtls_rec.fa_location_id <> p_dest_fa_location_id
1013:
1014: IF l_upd_csi_i_assets = 'Y' THEN
1015: debug('Updating Inst-Asset link ');
1016: ---Now update the Source CSI_I_ASSETS.
1017: l_src_inst_asset_rec.instance_asset_id := p_src_fa_inst_dtls_rec.instance_asset_id ;
1018: l_src_inst_asset_rec.asset_quantity := p_src_fa_inst_dtls_rec.instance_asset_qty ;

Line 1016: ---Now update the Source CSI_I_ASSETS.

1012: END IF ; --p_src_fa_inst_dtls_rec.fa_location_id <> p_dest_fa_location_id
1013:
1014: IF l_upd_csi_i_assets = 'Y' THEN
1015: debug('Updating Inst-Asset link ');
1016: ---Now update the Source CSI_I_ASSETS.
1017: l_src_inst_asset_rec.instance_asset_id := p_src_fa_inst_dtls_rec.instance_asset_id ;
1018: l_src_inst_asset_rec.asset_quantity := p_src_fa_inst_dtls_rec.instance_asset_qty ;
1019: l_transaction_units := (-1)*p_transaction_units ;
1020:

Line 1057: END IF ; --l_upd_csi_i_assets = 'Y

1053: IF l_return_status = l_fnd_error THEN
1054: debug('Destination Inst-Asset link Failed'); --???
1055: RAISE e_error ;
1056: END IF ;
1057: END IF ; --l_upd_csi_i_assets = 'Y
1058:
1059: EXCEPTION
1060: WHEN e_error THEN
1061: x_return_status := l_fnd_error ;

Line 1629: csi_i_assets cia

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
1632: AND cii.instance_id = ciih.instance_id
1633: AND ciih.transaction_id = cit.transaction_id

Line 1643: FROM csi_i_assets cia

1639: CURSOR nsrl_asset_cur( p_instance_id NUMBER ) IS
1640: SELECT cia.instance_id,
1641: cia.fa_asset_id,
1642: cia.asset_quantity
1643: FROM csi_i_assets cia
1644: WHERE cia.instance_id = p_instance_id
1645: AND cia.asset_quantity > 0
1646: AND cia.active_end_date IS NULL ;
1647:

Line 2725: FROM csi_i_assets

2721: ,fa_book_type_code
2722: ,asset_quantity
2723: ,object_version_number
2724: ,fa_sync_flag
2725: FROM csi_i_assets
2726: WHERE update_status IN ('OUT_OF_SERVICE', 'IN_SERVICE')
2727: AND instance_id = c_instance_id
2728: AND asset_quantity > 0
2729: ORDER BY fa_asset_id ;

Line 2734: FROM csi_i_assets

2730:
2731: CURSOR inst_asset_avail_qty (c_instance_id IN NUMBER)
2732: IS
2733: SELECT SUM(asset_quantity)
2734: FROM csi_i_assets
2735: WHERE update_status = 'IN_SERVICE'
2736: AND instance_id = c_instance_id
2737: AND asset_quantity > 0 ;
2738:

Line 3889: csi_i_assets cia

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
3893: AND CII.inventory_item_id = l_inventory_item_id

Line 3907: csi_i_assets CIA

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
3911: AND nvl(CIIH.new_quantity, 0) - nvl(CIIH.old_quantity,0) < 0

Line 4248: FROM csi_i_assets

4244: AND cii.inventory_item_id = p_inventory_item_id;
4245:
4246: CURSOR cia_cur(p_inst_id IN number) IS
4247: SELECT instance_asset_id
4248: FROM csi_i_assets
4249: WHERE instance_id = p_inst_id
4250: AND asset_quantity > 0
4251: AND fa_sync_flag = 'Y';
4252:

Line 4255: FROM csi_i_assets cia,

4251: AND fa_sync_flag = 'Y';
4252:
4253: CURSOR cia_pending_in_fma(p_inst_id IN number) IS
4254: SELECT cia.instance_asset_id
4255: FROM csi_i_assets cia,
4256: fa_mass_additions fma
4257: WHERE cia.instance_id = p_inst_id
4258: AND cia.asset_quantity > 0
4259: AND cia.fa_asset_id is null