APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_ITEM_INSTANCES

Line 251: FROM csi_item_instances_h ciih,

247: BEGIN
248: DEBUG('inside '|| l_api_name || 'Get PA OU context');
249: SELECT pa.ORG_ID
250: INTO l_txn_ou_context
251: FROM csi_item_instances_h ciih,
252: csi_item_instances cii,
253: csi_transactions ct,
254: pa_projects_all pa
255: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id

Line 252: csi_item_instances cii,

248: DEBUG('inside '|| l_api_name || 'Get PA OU context');
249: SELECT pa.ORG_ID
250: INTO l_txn_ou_context
251: FROM csi_item_instances_h ciih,
252: csi_item_instances cii,
253: csi_transactions ct,
254: pa_projects_all pa
255: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id
256: AND ciih.instance_id = p_asset_attrib_rec.instance_id

Line 1423: ,csi_item_instances cii

1419: /*CURSOR catchup_cur (c_instance_asset_id IN NUMBER)
1420: IS
1421: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1422: FROM mtl_system_items_b msib
1423: ,csi_item_instances cii
1424: ,csi_i_assets cia
1425: WHERE msib.organization_id = cii.inv_master_organization_id
1426: AND msib.inventory_item_id = cii.inventory_item_id
1427: AND cii.instance_id = cia.instance_id

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

1680:
1681:
1682:
1683: CURSOR c_get_asset_subinventory IS
1684: SELECT 'N' from mtl_secondary_inventories msi , csi_item_instances cii
1685: WHERE msi.asset_inventory=1
1686: AND msi.secondary_inventory_name=l_inv_subinventory_name
1687: AND msi.organization_id=cii.inv_organization_id
1688: AND msi.organization_id= l_inv_organization_id

Line 1697: SELECT 'N' from csi_item_instances

1693: WHERE instance_id=l_instance_id
1694: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
1695:
1696: CURSOR c_instance_norm is
1697: SELECT 'N' from csi_item_instances
1698: WHERE (pa_project_id IS NOT NULL OR
1699: last_pa_project_id IS NOT NULL)
1700: AND instance_id =l_instance_id
1701: AND (active_end_date >SYSDATE OR active_end_date IS NULL );

Line 2062: FROM csi_item_instances_h ciih1

2058: CURSOR pending_txns_cur
2059: IS
2060: SELECT ct1.transaction_id,
2061: ct1.transaction_date
2062: FROM csi_item_instances_h ciih1
2063: ,csi_transactions ct1
2064: ,csi_txn_types ctt
2065: WHERE ct1.transaction_id = ciih1.transaction_id
2066: AND ct1.transaction_type_id = ctt.transaction_type_id

Line 2074: FROM csi_item_instances_h ciih,

2070: AND ctt.source_transaction_type NOT IN ('INTERORG_TRANS_SHIPMENT',
2071: 'ISO_SHIPMENT')
2072: AND ciih1.instance_id IN (
2073: SELECT ciih.instance_id
2074: FROM csi_item_instances_h ciih,
2075: csi_transactions ct
2076: WHERE ct.transaction_id = p_asset_attrib_rec.transaction_id
2077: AND ciih.transaction_id = ct.transaction_id)
2078: AND ct1.transaction_status_code = 'PENDING' ;

Line 2206: FROM csi_item_instances_h

2202:
2203: IF p_inst_loc_rec.transaction_id is not null THEN
2204: SELECT creation_date
2205: INTO l_time_stamp
2206: FROM csi_item_instances_h
2207: WHERE transaction_id = p_inst_loc_rec.transaction_id
2208: AND instance_id = p_inst_loc_rec.instance_id;
2209: ELSE
2210: l_time_stamp := p_inst_loc_rec.transaction_date;