DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1269: FROM csi_item_instances cii,

1265: IS
1266:
1267: CURSOR c1 IS
1268: SELECT 'X'
1269: FROM csi_item_instances cii,
1270: cs_incidents_all_b sr
1271: WHERE sr.incident_id = p_incident_id
1272: AND cii.instance_id = p_customer_product_id
1273: AND cii.inventory_item_id = p_inventory_item_id

Line 1333: FROM csi_item_instances cii,

1329: l_Internal_Party_Id NUMBER ;
1330:
1331: CURSOR c1 IS
1332: SELECT 'X'
1333: FROM csi_item_instances cii,
1334: cs_incidents_all_b sr
1335: WHERE sr.incident_id = p_incident_id
1336: AND cii.instance_id = p_customer_product_id
1337: AND cii.inventory_item_id = p_inventory_item_id