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

Line 332: csi_item_instances_h ciih

328:
329: CURSOR deploy_cur IS
330: SELECT 'Y'
331: FROM csi_transactions ct,
332: csi_item_instances_h ciih
333: WHERE ciih.instance_id = p_instance_id
334: AND ct.transaction_id = ciih.transaction_id
335: AND ct.transaction_date < p_transaction_date
336: AND ct.transaction_type_id in (110, 108, 132, 133);

Line 364: csi_item_instances_h ciih

360: IS
361: CURSOR txn_cur IS
362: SELECT ct.transaction_id
363: FROM csi_transactions ct,
364: csi_item_instances_h ciih
365: WHERE ciih.instance_id = p_instance_id
366: AND ct.transaction_id = ciih.transaction_id
367: AND ct.transaction_date < (SELECT ct1.transaction_date
368: FROM csi_transactions ct1

Line 933: 'FROM fa_books fb, fa_additions fad, csi_i_assets cia, csi_item_instances cii '||

929: := 'SELECT fad.asset_id, fad.asset_number, fad.asset_category_id, fad.asset_key_ccid, '||
930: 'fad.tag_number, fad.description, fad.manufacturer_name, fad.serial_number, '||
931: 'fad.model_number, fad.current_units, fb.book_type_code, '||
932: 'fb.date_placed_in_service, fb.cost, cia.instance_asset_id '||
933: 'FROM fa_books fb, fa_additions fad, csi_i_assets cia, csi_item_instances cii '||
934: 'WHERE fb.asset_id = fad.asset_id '||
935: 'AND fb.date_ineffective is null '||
936: 'AND cia.fa_asset_id = fad.asset_id '||
937: 'AND cii.instance_id = cia.instance_id ';

Line 1181: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';

1177: 'fma.date_placed_in_service, '||
1178: 'fma.reviewer_comments, '||
1179: 'fma.feeder_system_name, '||
1180: 'cia.instance_asset_id '||
1181: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';
1182:
1183: l_where_clause varchar2(240);
1184: l_and_clause varchar2(540);
1185:

Line 2259: FROM csi_item_instances_h ciih,

2255: cii.instance_usage_code,
2256: cii.quantity,
2257: nvl(ciih.old_quantity,0) old_quantity,
2258: ciih.new_quantity
2259: FROM csi_item_instances_h ciih,
2260: csi_item_instances cii
2261: WHERE ciih.transaction_id = p_csi_txn_id
2262: AND cii.instance_id = ciih.instance_id
2263: AND cii.inventory_item_id = p_inventory_item_id

Line 2260: csi_item_instances cii

2256: cii.quantity,
2257: nvl(ciih.old_quantity,0) old_quantity,
2258: ciih.new_quantity
2259: FROM csi_item_instances_h ciih,
2260: csi_item_instances cii
2261: WHERE ciih.transaction_id = p_csi_txn_id
2262: AND cii.instance_id = ciih.instance_id
2263: AND cii.inventory_item_id = p_inventory_item_id
2264: AND nvl(ciih.new_quantity, 0) - nvl(ciih.old_quantity,0) > 0;

Line 2472: FROM csi_item_instances_h CIIH,

2468: IF l_serial_code IN (2, 5) THEN
2469: BEGIN
2470: SELECT 'Y'
2471: INTO l_asset_exists
2472: FROM csi_item_instances_h CIIH,
2473: csi_item_instances CII,
2474: csi_i_assets cia
2475: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2476: AND CIIH.instance_id = CII.instance_id

Line 2473: csi_item_instances CII,

2469: BEGIN
2470: SELECT 'Y'
2471: INTO l_asset_exists
2472: FROM csi_item_instances_h CIIH,
2473: csi_item_instances CII,
2474: csi_i_assets cia
2475: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2476: AND CIIH.instance_id = CII.instance_id
2477: AND CII.instance_id = CIA.instance_id

Line 2490: FROM csi_item_instances_h CIIH,

2486: ELSE
2487: BEGIN
2488: SELECT 'Y'
2489: INTO l_asset_exists
2490: FROM csi_item_instances_h CIIH,
2491: csi_item_instances CII,
2492: csi_i_assets CIA
2493: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2494: AND CII.instance_id = CIIH.instance_id

Line 2491: csi_item_instances CII,

2487: BEGIN
2488: SELECT 'Y'
2489: INTO l_asset_exists
2490: FROM csi_item_instances_h CIIH,
2491: csi_item_instances CII,
2492: csi_i_assets CIA
2493: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2494: AND CII.instance_id = CIIH.instance_id
2495: AND CII.inventory_item_id = l_inventory_item_id

Line 2595: FROM csi_item_instances

2591: LOOP
2592:
2593: SELECT instance_id
2594: INTO l_instance_id
2595: FROM csi_item_instances
2596: WHERE inventory_item_id = l_inventory_item_id
2597: AND serial_number = srl_rec.serial_number;
2598:
2599: get_redeploy_flag(

Line 3218: FROM csi_item_instances cii,

3214: cii.inventory_item_id,
3215: fb.book_type_code,
3216: fb.date_placed_in_service,
3217: fb.cost
3218: FROM csi_item_instances cii,
3219: csi_i_assets cia,
3220: fa_books fb,
3221: fa_additions fab
3222: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id, cii.inventory_item_id)

Line 3256: FROM csi_item_instances cii

3252: ,cii.inventory_item_id
3253: ,fb.book_type_code
3254: ,fb.date_placed_in_service
3255: ,fb.cost
3256: FROM csi_item_instances cii
3257: ,csi_i_assets cia
3258: ,fa_books fb
3259: ,fa_additions fab
3260: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id,