APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_ITEM_INSTANCES

Line 295: FROM csi_item_instances_h ciih,

291: BEGIN
292: DEBUG('inside '|| l_api_name || 'Get PA OU context');
293: SELECT pa.ORG_ID
294: INTO l_txn_ou_context
295: FROM csi_item_instances_h ciih,
296: csi_item_instances cii,
297: csi_transactions ct,
298: pa_projects_all pa
299: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id

Line 296: csi_item_instances cii,

292: DEBUG('inside '|| l_api_name || 'Get PA OU context');
293: SELECT pa.ORG_ID
294: INTO l_txn_ou_context
295: FROM csi_item_instances_h ciih,
296: csi_item_instances cii,
297: csi_transactions ct,
298: pa_projects_all pa
299: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id
300: AND ciih.instance_id = p_asset_attrib_rec.instance_id

Line 1548: ,csi_item_instances cii

1544: /*CURSOR catchup_cur (c_instance_asset_id IN NUMBER)
1545: IS
1546: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1547: FROM mtl_system_items_b msib
1548: ,csi_item_instances cii
1549: ,csi_i_assets cia
1550: WHERE msib.organization_id = cii.inv_master_organization_id
1551: AND msib.inventory_item_id = cii.inventory_item_id
1552: AND cii.instance_id = cia.instance_id

Line 1870: SELECT 'N' from mtl_secondary_inventories msi , csi_item_instances cii

1866:
1867:
1868:
1869: CURSOR c_get_asset_subinventory IS
1870: SELECT 'N' from mtl_secondary_inventories msi , csi_item_instances cii
1871: WHERE msi.asset_inventory=1
1872: AND msi.secondary_inventory_name=l_inv_subinventory_name
1873: AND msi.organization_id=cii.inv_organization_id
1874: AND msi.organization_id= l_inv_organization_id

Line 1883: SELECT 'N' from csi_item_instances

1879: WHERE instance_id=l_instance_id
1880: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
1881:
1882: CURSOR c_instance_norm is
1883: SELECT 'N' from csi_item_instances
1884: WHERE (pa_project_id IS NOT NULL OR
1885: last_pa_project_id IS NOT NULL)
1886: AND instance_id =l_instance_id
1887: AND (active_end_date >SYSDATE OR active_end_date IS NULL );

Line 2326: FROM csi_item_instances_h ciih1

2322: CURSOR pending_txns_cur
2323: IS
2324: SELECT ct1.transaction_id,
2325: ct1.transaction_date
2326: FROM csi_item_instances_h ciih1
2327: ,csi_transactions ct1
2328: ,csi_txn_types ctt
2329: WHERE ct1.transaction_id = ciih1.transaction_id
2330: AND ct1.transaction_type_id = ctt.transaction_type_id

Line 2338: FROM csi_item_instances_h ciih,

2334: AND ctt.source_transaction_type NOT IN ('INTERORG_TRANS_SHIPMENT',
2335: 'ISO_SHIPMENT')
2336: AND ciih1.instance_id IN (
2337: SELECT ciih.instance_id
2338: FROM csi_item_instances_h ciih,
2339: csi_transactions ct
2340: WHERE ct.transaction_id = p_asset_attrib_rec.transaction_id
2341: AND ciih.transaction_id = ct.transaction_id)
2342: AND ct1.transaction_status_code = 'PENDING' ;

Line 2469: FROM csi_item_instances_h

2465:
2466: IF p_inst_loc_rec.transaction_id is not null THEN
2467: SELECT creation_date
2468: INTO l_time_stamp
2469: FROM csi_item_instances_h
2470: WHERE transaction_id = p_inst_loc_rec.transaction_id
2471: AND instance_id = p_inst_loc_rec.instance_id;
2472: ELSE
2473: l_time_stamp := p_inst_loc_rec.transaction_date;