APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_ITEM_INSTANCES_H

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 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 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 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